Hello,
The below statement selects all from orders table and joins the customers table where id=id. The problem is some rows in the orders table will not have a match in the customers tables so the left join gives all those records a NULL value. including the ambiguous 'id' field so now when I go print the results the $line[id] becomes "NULL" for rows where there was no match . How can I keep the id field from the orders table even if there was no join for that row. Hope that is not to confusing.
Tracy
SELECT * FROM orders
LEFT OUTER JOIN customers ON orders.id = customers.id
