Michael Tocik (3/7/2011)
Hi,I have two order tables that I am trying to join. Both have have 13 records in them but when I do an inner join on the order number I get 169 records. Both tables have a data type of varchar(7) Here is the join;
SELECT INVOICE_DETAIL_CONF_ALL.order_number
FROM INVOICE_DETAIL_CONF_ALL
inner join ORDER_EXTRACT_AUTO
on [Ord No] = ORDER_NUMBER
What am I missing?
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