468,103 Members | 1,229 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,103 developers. It's quick & easy.

New to SQL and need a query creating help cant figure out how to complete this

I have the following tables with the following Coumns

Product -- Partnumber, description, shortcodeid
Shortcc -- shortcodeid
module -- moduleid, shortcodeid
Salesitem -- salesorderid, accountid, Partnumber, saleslineid
configuration -- moduleid, accountid

I am looking for the following colums back

accountid salesorderid saleslineid partnumber module

so 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.
Dec 13 '07 #1
0 736

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

13 posts views Thread by John young | last post: by
5 posts views Thread by moondaddy | last post: by
16 posts views Thread by NCRStinks | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.