How to write this query - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to write this query

Author

Topic

AAAV
Posting Yak Master

152 Posts

Posted - 2010-04-01 : 11:22:31

i have a table A
with vehicle id , part number 1, part number 2
i have table B with
part number and part price

i want
vehicle id, part number1, part price 1, part number 2 , part price 2 in the putput
how to do this?

PackRat
Starting Member

26 Posts

Posted - 2010-04-01 : 11:27:37

need to join talbe B twice, once for each part number;


SELECT
      [A].[vehicle id]
    , [A].[part number1]
    , [PN1].[part price 1]
    , [A].[part number 2]
    , [PN2].[part price 2]
FROM A
    JOIN B PN1 ON A.[part number1]=PN1.[part number]
    JOIN B PN2 ON A.[part number2]=PN2.[part number]

_____________________________
wrote this on my TRS-80 COCO4

<PakRat/>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources