Using Where Clauses W/ INNER JOINS
I'm trying to write a MySQL query that would call about 5 databases using an INNER JOIN. All of the databases use ID.
So the query I have so far is...
SELECT ......
FROM ((DB_1
INNER JOIN DB_2
USING (ID)
INNER JOIN DB_3
USING (ID))
But if I use an additional WHERE clause, it's going to apply to the entire set of DBs right? Suppose only one DB has a unique column labelled COLOR.
So, is it possible to use the clause "WHERE color = green"?
Reduce stress | Stay focused | Keep positive and balanced