با تشکر از پاسخ دوستان.

در ادامه دو مثال دیگه هم آوردم درباره این موضوع



SELECT [column names]FROM tableA AS a, tableB AS b, tableC as cWHERE b.blah = a.blahAND c.foo = a.fooAND [more where conditions]






SELECT [column names]FROM     tableA AS a     LEFT JOIN tableB AS b ON b.blah = a.blah    JOIN tableC as c ON c.foo = a.foo