Subqueries?

[pqwerty]

I'm using MySQL Control Center 0.9.2-beta. Will this take subqueries? I'm trying to extract data from tables in two different databases, and I'm not all familiar with JOINS. What is the syntax to do this in a subquery? In a JOIN?

Thanks in advance!

[wip3ouT]

joining tables from diff. databases

I havent heard of this Control Center thing...but I do know that you can select from different databases & tables using something like the code below:

select * from <database-name1>.<table-name>
inner join <database-name2>.<table-name>
on <database-name1>.<table-name>.<column>
= <database-name2>.<table-name>.<column>;

Hope this helps you. Lemme know if you want some more stuff on JOINs etc.