query for codes assigned to providers

[babysilvertooth]

HI,
Looking to see if there is query to find out which codes have been assigned to a provider.
For example, all my Oral surgery codes were assigned to the surgeon, but I have set up things now to work better so codes should change when dropped into the providers operatory under Standard fee schedules.

Thanks

[joes]

Our Query Example Page (https://opendentalsoft.com:1943/ODQuery ... yList.aspx) has query #1223 which provides a list of all procedure codes that are assigned to a specific provider, and the provider they are assigned to.

/*1223 Procedure codes with a default provider assigned*/
/*Query code written/modified: 01/04/2017*/
SELECT p.Abbr,
pc.ProcCode,
pc.Descript
FROM procedurecode pc
INNER JOIN provider p ON p.ProvNum=pc.ProvNumDefault
WHERE pc.ProvNumDefault<>0
ORDER BY pc.ProcCode