Open Dental Forum

I want to display ADA Code, Description and Fee for a fee schedule for a range of codes.

This query gives me the ADA Code and Description but I am having trouble figuring out how to change the query to add the fee.

SELECT ProcCode AS Code, Descript AS Description FROM procedurecode INNER JOIN fee ON fee.CodeNum = procedurecode.CodeNum WHERE ProcCode >= 'D7140' AND ProcCode <= 'D7953' AND fee.FeeSched = 53 ORDER BY Code Asc

Your query is pretty close to selecting all the information you need.
I have edited the query to add in a select for the fee.Amount as well as a couple of Where-clause additions to narrow down your fee to the clinic and provider default (0 clinic/prov). If you need provider and clinic overrides, just change the values on those Where-clauses to the appropriate primary keys.
Hope this helps!

That works.

Thanks Allen