Sunday, January 5, 2014

JOIN AND UNION in same query

SELECT column_name,column_name2 FROM table_name
INNER JOIN table_name2 on table_name.column_name=table_name.column_name2 
UNION
SELECT column_name,column_name2 FROM table_name3 

No comments:

Post a Comment