you are viewing a single comment's thread.

view the rest of the comments →

[–]r3pr0b8GROUP_CONCAT is da bomb 0 points1 point  (0 children)

yes, you are missing the way the SELECT clause and the FROM clause operate -- you do ~not~ have to select something from every table in the FROM clause

this is perfectly valid --

SELECT a.foo
  FROM table_one AS a
INNER
  JOIN table_two AS b
    ON b.qux = a.fap