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
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%');
Yekku · Apr 22, 2022 12:49 AM
Thanks Yekku. Do you mind if I ask you some follow-up questions privately. Thanks!
Deke · Apr 22, 2022 2:07 AM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion