ClientManager
Signout
Clients
Global Settings
EMR Sql Queries
CPS Sql Queries
Logs
Edit
Centricity Sql Query
Order
Name
Query
select p.CPTCode, p.Description, p.Ledger,p.LastModified, p.LastModifiedBy, p.ProceduresId, fs.FeeScheduleName, pfs.Fee, pfs.Allowed, pfs.LastModified, pfs.LastModifiedBy from Procedures p LEFT JOIN ProceduresFeeSchedule pfs ON pfs.ProceduresId = p.ProceduresId LEFT JOIN FeeSchedule fs on fs.FeeScheduleId = pfs.FeeScheduleId WHERE p.cptcode in ('j0601', 'j0602', 'j0603')
Notes
Back to List