MS SQL

MS SQL RSS

Doing a two-tabled query

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Dec 2008

Posts: 25

Reputation: Tonkz is an unknown quantity at this point

Solved Threads: 0

Tonkz

Offline

Light Poster

Doing a two-tabled query

Apr 22nd, 2009

For example you want two tables that have a column that has an identical id and that id you want to print out in another table. how will you code it?

•

Join Date: Apr 2009

Posts: 818

Reputation: Airshow is on a distinguished road

Solved Threads: 116

Airshow

Offline

Practically a Posting Shark

Re: Doing a two-tabled query

Apr 22nd, 2009

Tonkz,

Oh boy, you're going to have fun. You're about to learn all about SQL joins. Look them up in the MS SQL manual (w3schools provides a reasonable primer).

In short, there's no unique answer to your question. It depends on which type of join is appropriate to your tables and the particular query you are trying to compose, which itself depends on the way in which your data is normaisled into tables and how the tables are keyed.

Have fun

Airshow

•

Join Date: Dec 2008

Posts: 25

Reputation: Tonkz is an unknown quantity at this point

Solved Threads: 0

Tonkz

Offline

Light Poster

Re: Doing a two-tabled query

Apr 23rd, 2009

Oh I read about that, but it seems that I was doing it wrong my code doesn't work. Maybe I should have posted it. Well i'll post it tomorrow hopefull too sleepy to do it now =.= by the way, you're right it was fun!!!

•

Join Date: Apr 2009

Posts: 217

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 31

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Re: Doing a two-tabled query

Apr 23rd, 2009

SELECT TABLE1.*,TABLE2.* FROM TABLE1 INNER JOIN TABLE2
ON TABLE1.ID=TABLE2.ID

NOW EXAMINE THE RESULT. CHANGE INNER word by LEFT,RIGHT,FULLER..........

MARK AS SOLVED if its help you.

REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com

•

Join Date: May 2007

Posts: 146

Reputation: Stylish is an unknown quantity at this point

Solved Threads: 14

Stylish

Offline

Junior Poster

Re: Doing a two-tabled query

Apr 23rd, 2009

Inner Join (id is foreign key)

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT *
FROM table1 t1, table2 t2
WHERE t1.id = t2.id
SELECT *
FROM table1 t1, table2 t2
WHERE t1.id = t2.id

Left Outer Join (id is foreign key)

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT *
FROM table1 t1, table2 t2
WHERE t1.id *= t2.id
SELECT *
FROM table1 t1, table2 t2
WHERE t1.id *= t2.id