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

[mountainbig]

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.