wilded
7/10/2018 - 9:10 AM

MySQL Join Query

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