I've a simple question about SQL usage but i don't know even i can formulate this question. Well, i will try :
I've a teacher_course table with columns cd_course, cd_teacher => teacher_course(cd_teacher,cd_course) and i've a set of pairs that contains the values for these columns, like {(1,2),(23,11),(563,341),...}.
Is there a way to build a query to select rows that matchs these pairs ? Like a "in" extension (or something else) :
select * from teacher_course where (cd_course,cd_teacher) in ((1,2),(23,11),(563,341))
?
I would appreciate any help. Thanks in advance.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
