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

[Mikol22]

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 the procedurelog stores each and every procedure for a patient but is the "CodeNum" column contains the procedurecode that patient will do?

[jordansparks]

procedurecode.CodeNum = procedurelog.CodeNum

[Mikol22]

You are right! I cannot believe i didnt notice that before. Thank you