SELECT from multiple tables

[admin]

I can't help think this should be real easy but I can't for the life of me get it to work.

I was to display all the records from all tables with the same field specifies

i.e. Display all records where the name is equal to "paul" from all the tables in the database links.

I would have thought

SELECT * FROM news, dvd, shopping where create='paul g'

this just reports an ambigous error, and if I enter:

SELECT * FROM news, dvd, shopping

if returns thousands of records, hundred's of duplicates.

What am I doing wrong???

regards, pgudge