simple mysql query

[lli2k5]

I have two tables A and B with the same column names.

From PHP, how do I insert into B, everything that is in A and not already in B?

[stolzyboy]

give this a look

http://dev.mysql.com/doc/refman/5.1/en/insert-select.html

[lli2k5]

Thanks, I always thought it had to do something with UNION

[lli2k5]

why doesn't this query work?

INSERT INTO A SELECT*FROM B WHERE title NOT IN(SELECT title FROM A)

I'm trying to insert everything in B into A that's not already in A.