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 ...