Code: Select all
procedures:
id_primary, id_other
sequences:
id_primary, id_other2
procedure_sequences
id_primary, id_procedure, id_sequenceFor the life of me I cannot wrap my head around how this would be solved using JOIN's?
I am sure the query is relatively simple but I cannot figure it out.
EDIT | Would I have to use a sub-query to solve this issue? By first querying the sequences and junction table to find all the procedure ID's and then SELECT all the procedures whose ID's were previously returned???
Cheers,
Alex