Posted by: Deke April 21, 2022
SQL HELP
Login in to Rate this Post:     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”
Read Full Discussion Thread for this article