Why does the order of the SELECT statements in the UNION affect the result?<BR><BR>This first SQL produces the result I want.<BR><BR>SELECT cat_id AS catid, manufacturer AS mfr, model, a_class_id ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Simply join two SELECT statements with the UNION keyword to combine the results of two queries into a new table. When working with databases other than Microsoft's SQL Server, check the manual to ...

See OUTER UNION. For example, when performing a set operation on two table-expressions, PROC SQL matches the first specified column-name (listed in the SELECT clause) from one table-expression with ...

BR><BR>Now as I understand it if I did:<BR><BR>select EmpAddress<BR>from tbl_Employees<BR>UNION<BR>select ContractAddress AS EmpAddress<BR>from tbl_Contractors<BR>WHERE ContractCompany = 'EDS';<BR ...