MySQL Join Query
\!h ALTERNATIVE 1
SELECT
a.FIELD_NAME AS NEW_FIELD_NAME,
b.FIELD_NAME2 AS NEW_FIELD_NAME2,
c.FIELD_NAME3 AS NEW_FIELD_NAME3,
d.FIELD_NAME4 AS NEW_FIELD_NAME4
FROM
TABLE a,
TABLE2 b,
TABLE3 c,
TABLE4 d,
WHERE
a.ID = b.ID
AND
b.ID = c.ID
AND
c.ID = d.ID
GROUP BY NEW_FIELD_NAME
ORDER BY NEW_FIELD_NAME1 ASC
\!h ALTERNATIVE 2
SELECT TABLE1.*
FROM TABLE1
INNER JOIN TABLE2
ON TABLE1.ID = TABLE2.ID2
WHERE TABLE1.FIELD1 > 0