SQL HELP - Sajha Mobile
SAJHA MOBILE
SQL HELP
Posts 3 · Viewed 4644 · 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 is reading Sano Sansar Music
Visitor is reading किन पढ्नु अमेरीकामा???
Visitor is reading Time 2 Laugh - news bloopers
Visitor is reading Mero Haiku
Visitor from US is reading WNSO-ICON Scholarship Programme
Visitor is reading CHAUTARI - VI
Visitor is reading VANILLA
Visitor is reading Kothe rajnitigya harulai suchana
You might like these other discussions...
kale dai » salikram jamakattel
lost $3500 on penny stocks !!!
· Posts 9 · Viewed 875 · Likes 1
independent
When Woody Harrelson joked about the media
· Posts 1 · Viewed 39
furke » haal haal pandit
Trasiting through Istanbul, Turkey
· Posts 2 · Viewed 177
Sajha Classifieds
Classifieds Summary: Jobs in MA, Room/Apt in MA,VA
· Posts 1 · Viewed 47
xkavrepalanchok » ShreeRaam
Obama Illinois federal judge --- rules illegal migrants can carry guns legally !
· Posts 5 · Viewed 373
NepalNews Sajha
News Summary from Nepal for Monday, April 29, 2024
· Posts 1 · Viewed 51
xkavrepalanchok » Tesla guy
They are openly permitting undocumented immigrants to participate in federal elections in Arizona now.
· Posts 3 · Viewed 750 · Likes 2
xkavrepalanchok » Tesla guy
They deserve priority due to their language barrier. But whose fault is that? Entering the country illegally knowing English is essential.
· Posts 2 · Viewed 222
xkavrepalanchok
If the democrats didn't have double standards, they'd have no standards at all.
· Posts 1 · Viewed 138
Sajha Classifieds
Classifieds Summary: Room/Apt in CO,VA
· Posts 1 · Viewed 111



Your Banner Here
Travel Partners
Travel House Nepal