← Back to Kurakani

SQL HELP

Original Post

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”

Deke
Apr 21, 2022 8:45 PM · 21,844 views
2 Replies
Yekku Apr 22, 2022 12:49 AM
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 Apr 22, 2022 2:07 AM
Thanks Yekku. Do you mind if I ask you some follow-up questions privately. Thanks!
Login to join the conversation.

You might be interested in...

Recent Classifieds View all
Upcoming Events View all
Service Providers View all
Ask Sajha AI Assistant