Hello

please forgive me if this is really easy, but I am new to the world of mysql and am on a fairly tight timeframe.
I am trying to find all the values in one table which don't appear in another.
ie, I have a database x, which has a table, y, which lists shots in it.
I have another database a, which has another table, b, which also lists all the shots. I need to know which shots in x.y don't appear in a.b

simple, I am sure, but it's driving me nuts.

thanks!
sez

assuming the two databases are accessible by the same mysql server

You might have to use select t1.shots instead of select shots
right at the beginning of Rudy's solution. I tried his solution since I hadn't done selects from multiple dbs before and got an ambiguous field error until I changed to t1.shots.

DOH!

thanks, guelphdad