Apart from some DDL code to see what the tables look like? So just guessing wild: - All the rows in both tables actually have the same Order_number - You joining on 2 columns from the same table. Try and add the table name before the column. /T Michael Tocik SSCertifiable Points: ...