Search found 3 matches

by Mikol22
Wed Jun 16, 2021 11:35 am
Forum: Advanced Topics
Topic: Is ProcCode in "procedurecode" table same as "CodeNum" in "procedurelog" table?
Replies: 2
Views: 8500

Re: Is ProcCode in "procedurecode" table same as "CodeNum" in "procedurelog" table?

You are right! I cannot believe i didnt notice that before. Thank you
by Mikol22
Tue Jun 15, 2021 4:05 pm
Forum: Advanced Topics
Topic: Is ProcCode in "procedurecode" table same as "CodeNum" in "procedurelog" table?
Replies: 2
Views: 8500

Is ProcCode in "procedurecode" table same as "CodeNum" in "procedurelog" table?

I am testing out writing queries. I know the procedurecode contains all the codes while the procedurelog contains each procedure for a patient (so John with an ID of 555 can have 6 rows, each row containing a different CodeNum) I wanted to get all patients that have a specific procedurecode. I know ...
by Mikol22
Tue Jun 08, 2021 7:41 pm
Forum: Advanced Topics
Topic: Unscheduled Hygenie SQL does not
Replies: 1
Views: 8266

Unscheduled Hygenie SQL does not

Hello I am trying to understand how OpenDental does commands. Right now I am trying to get all patients that do not have a scheduled hygenie. I came up with this SQL code: https://pastebin.com/eT61313L It does not seem to be correct though and i am not sure why. Is there something about OpenDental a...