Web Analytics Made Easy -
StatCounter Subqueries? - CodingForum

Announcement

Collapse
No announcement yet.

Subqueries?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Subqueries?

    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!

  • #2
    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.

    Comment

    Working...
    X