Help with Query

[wjstarck]

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

[allends]

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!

Code: Select all

SELECT
  ProcCode AS CODE,
  Descript AS Description,
  fee.Amount AS Fee
FROM
  procedurecode
  INNER JOIN fee
    ON fee.CodeNum = procedurecode.CodeNum
WHERE ProcCode >= 'D7140'
  AND ProcCode <= 'D7953'
  AND fee.FeeSched = 53
  AND fee.ProvNum=0
  AND fee.ClinicNum=0
ORDER BY CODE ASC;

[wjstarck]

That works.

Thanks Allen