SQL HELP - Sajha Mobile
SAJHA MOBILE
SQL HELP
Posts 3 · Viewed 4622 · Go to Last Post
Deke
· Snapshot 0
Like · Likedby · 0
Anybody up for a sample SQL help.

ClaimHeader
PK-claimid
FK-enrollid
FK-providerid
StartDate
EndDate
PlaceOfService
TotalBilledAmount

ClaimDetail
PK-claimid
PK-claimline
ServiceCode
LineBilledAmount

Member
PK-memberid
FirstName
LastName
Gender

Enrollment
PK-enrollmentid
FK-memberid
Program
Network

Display the claim ID, member ID and sum of line billed amounts for members enrolled in the “Medi-Cal” program in the “HIL” network where the service code begins with “G”
Yekku
· Snapshot 61
Like · Liked by · 0
Select Distinct A.Claimid, C.memberid, Sum(b.LineBilledAmount)
from ClaimHeader A, ClaimDetail B, Member C, Enrollment D
where A.claimid = B.claimid
And A.enrollid= D.enrollmentid
And D.memberid C.memberid
And D.Program = 'Medi-Cal'
And D.Network = 'HIL'
And B.ServiceCode like ('G%');
Deke
· Snapshot 82
Like · Liked by · 0
Thanks Yekku. Do you mind if I ask you some follow-up questions privately. Thanks!
Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
Visitor from US is reading SQL HELP
Visitor from US is reading Flying to Nepal on Jan 14, 2014: EWR-HGW-DOH
Visitor from US is reading Recommendation for Health and IT related subject
Visitor is reading पुरूषमा भन्दा महिलामा किन वढी यौन चाहाना हुन्छ ? यस्ता छन् क
Visitor from DE is reading How a muslim boy Ahmed fooled whole of America
Visitor from US is reading ओरिपरि जिन्ग्रीङ्ग ,माझमा ठिंन्ग्रिंङ्ग
Visitor from US is reading ~ * चौतारी १५४ *~
Visitor from US is reading बोस्टन सम्मेलन सम्बन्धि वास्तविकता र छेवाङको प्रतिवेदन
Visitor is reading SLC topper बारे सानो update
You might like these other discussions...
Lucky_Nepali » Lucky_Nepali
TPS advance parole Travel document i-131, Class of Admission ?
· Posts 3 · Viewed 377
kale dai » sojho_bahun
lost $3500 on penny stocks !!!
· Posts 4 · Viewed 386 · Likes 1
Bidurthapa » ShreeRaam
TPS Reregistration and EAD Approval Timeline.......
· Posts 3 · Viewed 197 · Likes 1
wakeyour_mind » polisci
These Student Protests Against Israel Are the Most Important Political Movement of Our Lifetime
· Posts 4 · Viewed 331
NepalNews Sajha
News Summary from Nepal for Friday, April 26, 2024
· Posts 1 · Viewed 71
Smriti-malla
मरेर गएनि कहिल्यै नमर्ने मान्छे!
· Posts 1 · Viewed 249
bandedv2023 » pitambar
ढ्याउ गर्दा दसैँको खसी गनाउच
· Posts 24 · Viewed 7548 · Likes 2
sm01234 » Logan
emergency donation needed
· Posts 26 · Viewed 2744 · Likes 5
Sajha Classifieds
Classifieds Summary: Room/Apt in MA
· Posts 1 · Viewed 119
NepalNews Sajha
News Summary from Nepal for Thursday, April 25, 2024
· Posts 1 · Viewed 134



Your Banner Here
Travel Partners
Travel House Nepal