Search found 3 matches
- 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: 10433
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
- 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: 10433
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 ...
- Tue Jun 08, 2021 7:41 pm
- Forum: Advanced Topics
- Topic: Unscheduled Hygenie SQL does not
- Replies: 1
- Views: 10240
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...