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
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.