A SQL Question...
Bear with me... I'm kinda new here.
I am trying to query table1, selecting records that do NOT have a relation in a subset from table3 that is related to table2.
Example:
table1(Trick table)
1_id,trickName,trickDescription
table2(Magician table)
2_id,lastName,firstName
table3(Trick-Magician-Knows table)
2_id,1_id
if I choose some magician I want a list of tricks he/she DOES-NOT know.
thanks for any insight !