mario.lat_ wrote:Yes, MySQL supports database specifiers in the FROM clause, but the> I'd like, for example, query:
> SELECT DbB.person.name , DbA.cities.state FROM
syntax is different from what you use above.
Here is what I would write:
SELECT B.person_name, A.state
FROM DbA.cities AS A JOIN DbB.person AS B
ON A.name = B.city