![open dental help open dental help](https://thumbs.dreamstime.com/z/drilling-dentist-treatment-feale-patient-open-mouth-30943297.jpg)
SELECT provider.Abbr, inssub.SubscriberID, patient.PatNum, SUM(procedurelog.procfee) AS '$Produc_',ĪND (Date(claim.DateService)=Date(procedurelog.ProcDate))) AS '$PlanEst_',ĪND (Date(DatePay)=(Date(procedurelog.ProcDate)))) AS '$Patpay_',ĪND (Date(AdjDate)=(Date(procedurelog.ProcDate)))) AS '$Adjustments_',ĪND (Date(DatePay)=(Date(procedurelog.ProcDate)))) AS 'HowPaid_' Can someone please help me add the insurance carrier if it exists without removing the patients who don't have insurance. This is what I have, it will give me provider selected, subscriber ID if it exists, patient name, production for the selected dates, insurance estimate, patient payment, adjustments and how patient paid. I tried to add the insurance carrier to the query, but then I don't get the patients that have no insurance. ORDER BY procedurelog.ProcDate,patient.LName, patient.FName WHERE procedurelog.ProcDate BETWEEN AND procedurelog.ProcStatus=2ĪND provider.Abbr LIKE BY procedurelog.ProcDate,patient.PatNum
![open dental help open dental help](https://s3-us-west-2.amazonaws.com/issuewireassets/primg/69025/67260-moolah-box926238276.jpg)
INNER JOIN provider ON provider.ProvNum=procedurelog.ProvNum INNER JOIN procedurelog ON patient.PatNum=procedurelog.PatNum INNER JOIN definition ON payment.PayType=definition.DefNumĪND (Date(DatePay)=(Date(procedurelog.ProcDate)))) AS 'ComoPago_' INNER JOIN payment ON paysplit.PayNum=payment.PayNum SELECT provider.Abbr, patient.PatNum, SUM(procedurelog.procfee) AS '$Produc_',ĪND (Date(claim.DateService)=Date(procedurelog.ProcDate))) AS '$EstPlan_',įROM paysplit WHERE patient.PatNum=paysplit.PatNumĪND (Date(DatePay)=(Date(procedurelog.ProcDate)))) AS '$PctePago_',ĪND (Date(AdjDate)=(Date(procedurelog.ProcDate)))) AS '$Ajustes_', I would like to add the patient's subscriber ID but can't find a way to do it. I've been trying to edit the following query and it's almost what I need.