querying two tables in one statement

ASP Free Forums Sponsor:

August 4th, 2004, 10:13 AM

senrab

Registered User

Join Date: Aug 2004

Posts: 3

Time spent in forums: < 1 sec
Reputation Power: 0

querying two tables in one statement

i am new to sql but im learning an wondered if anyone can help me with this problem. i have four tables but need to find info from two of them in the one select statement,
the tables i have are

Order(Order_No, Part_no)
Part(Part_No, Part_description, Part_Price)

i need to find the parts which were ordered on order number 10 and their prices.

so far i have this

select Order.Part_No, Part.Part_price

from order, part
where Order.order_no = 10 AND Order.Part_No = Part.Part_No

but i know this isnt right as i would have to find the part numbers from the first table and use these to query the second table to get the prices but i dont know how to do this using one statement instead of it being long winded and using two or is that what i have to do?

can anyone help??? this is probably simple to you guys after reading the more advanced posts!!!

August 4th, 2004, 11:45 AM

Memnoch

Unholy Moderator

ASP Free God 14th Plane (11500 - 11999 posts)

Join Date: Oct 2003

Location: In hell, where did you think?

Posts: 11,776

Time spent in forums: 3 Weeks 5 Days 8 h 27 m 42 sec
Reputation Power: 470

Code:

SELECT A.Part_No, B.Part_Price
FROM Order As A
INNER JOIN Part As B On (A.Part_No = B.Part_No)
WHERE A.Order_No = 10

August 4th, 2004, 01:59 PM

senrab

Registered User

Join Date: Aug 2004

Posts: 3

Time spent in forums: < 1 sec
Reputation Power: 0

i think thats a bit too advanced for me at the moment

is this correct????

select Order.Part_No, Part.Part_Price

from Order, Part

where Part_No IN

(select Part_No from Order where Order_No = 10)

Quote:

Originally Posted by Memnoch

Code:

SELECT A.Part_No, B.Part_Price
FROM Order As A
INNER JOIN Part As B On (A.Part_No = B.Part_No)
WHERE A.Order_No = 10

Viewing: ASP Free Forums > Database > SQL Development > querying two tables in one statement

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump