[RESOLVED] mysql where in operation on two or more fields?

[blackhorse]

Here is the example

I have two tables

books_1:

title
name
credit

The data in books_1

'mysql manual', 'bob', 'author';
'mysql manual', 'smith', 'editor';
'mysql manual', 'bill', 'editor';
'php programming', 'jean', 'author';
'php programming', 'joe', 'publisher';
'apache', 'joe', 'publisher';

books_2:

title
name
credit

The data in books_2

'mysql manual', 'robert', 'author';
'mysql manual', 'smith', 'editor';
'mysql manual', 'bill', 'editor';
'php programming', 'jean', 'author';
'php programming', 'joe', 'publisher';
'java programming', 'joe', 'publisher';

For example, I can query like this

SELECT * FROM books_1 WHERE title NOT IN (SELECT title FROM books_2);

But could I query like this ?

SELECT * FROM books_1 WHERE (title, name) NOT IN (SELECT title, name FROM books_2);

Or I have to use concatenate in the second query case?

Thanks!

Tested, yes it works!