mister.magoo (7/31/2013)
mcummings (7/31/2013)
adding sorels.fpartno = aritem.fpart cuts it down from 3075 to 1204but there's no fitem in sorels
As I said, WE are guessing - you shouldn't be .
If you don't understand how those tables are related, you should not be changing anything until you learnt the relationships.
Sorry to be blunt, but if you are being paid to do this, you should learn not guess.
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events