Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Learn how to use SQL joins to check and fix data integrity and consistency issues across tables. See SQL join examples for finding missing values, duplicates, mismatches, and outliers.

12347 998854 4 12347 998856 8</pre><BR><BR>I need a SQL statement that will use po_ln_no to get the PO number (matches up with po_no in po table) and give the ship_via_cod value from the po table.

In most implementations of SQL, you pull information from two tables by using a SELECT command in this form: SELECT table1.column1, table1.column2, table2.column1, table2.column2 FROM table1, table2 ...