Hi there,<BR><BR>I've got a little problem. I need to join two tables both have the field "Product_ID" but the contents of the columns differ slightly. For example:<BR><BR>Table 1<BR>Field ...

Read this SQL tutorial to learn when to use SELECT, JOIN ... return a column that is the result of a subselect. The following example uses two tables: SELECT column1 FROM table1 WHERE EXISTS ...

In this example, Transact-SQL will create a new table with all columns from the rows in "old ... clause in both SELECT statements. Simply join two SELECT statements with the UNION keyword to ...