Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mountainbig
Starting Member
1 Post |
 Posted - 2007-12-13 : 15:14:34
|
| I have the following tables with the following CoumnsProduct -- Partnumber, description, shortcodeidShortcc -- shortcodeidmodule -- moduleid, shortcodeidSalesitem -- salesorderid, accountid, Partnumber, saleslineidconfiguration -- moduleid, accountidI am looking for the following colums backaccountid salesorderid saleslineid partnumber moduleso i have all these columns and tables but all i need to do is find all sales with modules that do not exist in the module table by joining these tables and comparing the modules in the sales orders to the module tables.please help havent the faintest idea where to start and what to do i am using the sql server management studio for the query. |
|
|
|
|
|
New to SQL and need a query creating help cant fig