473,408 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Need help generating a Query

Greetings!

I have a table for for sales order with module information related to sales.
i have a Module table with a list of modules.

i am trying to create a query to pull all the sales accounts with modules that do not exist in the modules table.

and i need the following columns pulled in the results
AccountID AccountName SalesOrderID SalesLineID PartNumber PartNumberDescription Module

could someone please help me in creting this simple query. i am a intern in a new position and i need help.

thanks in advance
MB

also i would like to find out if there is a outside application that would allow me to use SQL server managemnt to create a query through a wizard or some thing like that?

how should i go about improving my SQL query experiance.

please advice.
Dec 12 '07 #1
1 978
ck9663
2,878 Expert 2GB
Greetings!

I have a table for for sales order with module information related to sales.
i have a Module table with a list of modules.

i am trying to create a query to pull all the sales accounts with modules that do not exist in the modules table.

and i need the following columns pulled in the results
AccountID AccountName SalesOrderID SalesLineID PartNumber PartNumberDescription Module

could someone please help me in creting this simple query. i am a intern in a new position and i need help.

thanks in advance
MB

also i would like to find out if there is a outside application that would allow me to use SQL server managemnt to create a query through a wizard or some thing like that?

how should i go about improving my SQL query experiance.

please advice.

try:
select
AccountID AccountName SalesOrderID SalesLineID PartNumber PartNumberDescription Module from SalesTable
where Module not in (select Module from ModuleTable)
Dec 12 '07 #2

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

Similar topics

2
by: Ryan | last post by:
We have an MIS system which has approx 100 reports. Each of these reports can take up to several minutes to run due to the complexity of the queries (hundreds of lines each in most cases). Each...
1
by: Robert | last post by:
I have two tables (classes and students). Right now, I'm generating a report in asp that shows a list of classes, the enrollment for each class, and how many seats are available (see query below)....
8
by: Keith Smith | last post by:
I know this is a little off topic but I hope it is still acceptable to this forum. Please read this carefully. I am not looking for a quick answer - I am hoping to find someone who has been in my...
8
by: Thomas R. Hummel | last post by:
Hello, I am currently working with a data mart. The business wants a view of the data that shows columns from the main table along with up to 6 codes from a related table (not related by the...
5
by: nephish | last post by:
Hello there, i have an app that i need to be able to publish a link to download a csv file. i know that i can use php to make the file, but how to i link to it through php. like if i have an...
5
by: Cyrax1033 | last post by:
I have yet a new issue that is the only factor stopping me from adding on the last feature to the database; all help is very much appreciated! In my database is are two tables: one for inserting...
3
by: dawnerd | last post by:
I am having troubles with my script. It is supposed to generate a "map" from a serialized array stored in a database. However, it is not generating any html. I know the data is being retrieved from...
1
by: sparks | last post by:
we are generating numbers for the data collection people. this worked fine for a while.. Private Sub generatenumber() Dim db As DAO.Database Dim rs As DAO.Recordset Dim StudentNumber As...
2
by: amollokhande1 | last post by:
Hi, I am using the sqldataadapter for generating the output of query in the form of XML. I have following sample query select FirstName,LastName from Users where userid='Amol' After fetching...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.