mysql table join from multiple DB's

[Jamez]

Here's the situation...

DB1
Table1
----------------
name | company | url

Table2
----------------
name1*

DB2
Table3
----------------
company*

I have a list of companies in table3. I want to show the entire list of companies based on wether or not a customer already has them in an entry in table1. The only variable i start with is the "name"... i need to select all the rows from table1 where name=name and subtract the results from the list in table3 and then echo the result...

anyone help with this query b/c i don't know where to start 😕

[pete_bisby]

Is Table2 the "name" you want to match with name in Table1?

If so ...

SELECT Table1.name, Table1.company
FROM Table1 INNER JOIN Table2 ON Table1.name=Table2.name
  LEFT JOIN Table3 ON Table1.company=Table3.company
WHERE Table3.company IS NULL;

If not ...

SELECT Table1.name, Table1.company
FROM Table1 LEFT JOIN Table3 ON Table1.company=Table3.company
WHERE Table1.name='name' AND Table3.company IS NULL;

For more information on table joins in MySQL use the following link:
http://dev.mysql.com/doc/mysql/en/join.html