nvoyatzopoulos (11/11/2012)
the other 2 tables just have data that we don't use except the companyid. so we just want to join the tables in companyid that is the same in all tables . all the other fields are in the second one ..thanks
Then what is the purpose of the joins if you have all the data that you need for this exercise all in one?
Also, if it really is one just one table with the data you're concerned with, it should be even easier for you to post some readily consumable data. Again, please read the article at the first link in my signature line below.
--Jeff Moden
Change is inevitable... Change for the better is not.