InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:36:07 GMT20http://www.sqlservercentral.com/Forums/Topic1074608-338-1.aspx[quote][b]Michael Tocik (3/8/2011)[/b][hr]dope!:blush:My mistake....I was joining on the wrong field[/quote]Easily done. Try to get into the habit of using table aliases:SELECT i.order_number FROM INVOICE_DETAIL_CONF_ALL iINNER JOIN ORDER_EXTRACT_AUTO o ON o.[Ord No] = i.ORDER_NUMBERTue, 08 Mar 2011 04:59:51 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1074608-338-1.aspxdope!:blush:My mistake....I was joining on the wrong fieldTue, 08 Mar 2011 04:47:46 GMTMichael Tocikhttp://www.sqlservercentral.com/Forums/Topic1074608-338-1.aspx[quote][b]Michael Tocik (3/7/2011)[/b][hr]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_NUMBERWhat am I missing?[/quote]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./TMon, 07 Mar 2011 23:54:16 GMTtommyhhttp://www.sqlservercentral.com/Forums/Topic1074608-338-1.aspxHi,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_NUMBERWhat am I missing?Mon, 07 Mar 2011 23:22:58 GMTMichael Tocik