tah le, aku tak biasae guna join2 nih, download
mysql manual ade dia cite pasal LEFT JOIN, INNER JOIN etc nih
Quote:
The NATURAL [left] JOIN of two tables is defined to be semantically equivalent to an INNER JOIN or a LEFT JOIN with a USING clause that names all columns that exist in both tables.
INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition.
|
baik pakai koma je (SELECT * FROM table1,table 2 WHERE .....), simple sket