help with this query

[Anishgiri]

I can't figure it out.

Let say I have table1 and table2.

table1 has exam_number, exam_title fields, table2 has exam_number,exam_title fields

Let say the values of the tables are

Table1
exam_number,  exam_title
 2                      3
 2                      4
 2                      5

Table2
exam_number,  exam_title
 2                     3
 2                     5

What I want to get is table1 row(exam_number,exam_title) values, that does not exist on table2 row. Meaning I should get 2,4 on table1,thanks..

[felgall]

It would be easier if you were to combine the two tables together and just add an extra field to represent whatever caused you to split it into two tables.

You might want to read up on database normalization.

[Anishgiri]

For simplicity,I did not include all the fields of the two table, it has a purpose why it's like that..

[guelphdad]

what have you tried?

[Old Pedant]

SELECT T1.* 
FROM table1 AS T1
LEFT JOIN table2 AS T2
ON ( T1.exam_number = T2.exam_number AND T1.exam_title = T2.exam_title )
WHERE T2.exam_number IS NULL