Groups | Blog | Home
all groups > sql server programming > september 2003 >

sql server programming : INNER JOIN



Anith Sen
9/30/2003 4:14:33 PM
Do:

SELECT a.ID, b.Naziv, a.Naziv AS Expr2, a.Namen,
c.Ime, a.Kreiran, a.Zaprt
FROM ToDos a
INNER JOIN Podjetja b
ON a.PodjetjeID = b.ID
INNER JOIN third_tbl c
ON c.joincol = <a.joincol or b.joincol>

-- Use the column on which you want to join with the third table.

--
- Anith
( Please reply to newsgroups only )

Oliver Young
9/30/2003 10:55:18 PM
I have this situation:

SELECT a.ID, b.Naziv, a.Naziv AS Expr2, a.Namen, c.Ime, a.Kreiran, a.Zaprt
FROM ToDos a INNER JOIN
Podjetja b ON a.PodjetjeID = b.ID

Two tables are connected. How can I connect third one? I need c.Ime field from third ( c ) table.

AddThis Social Bookmark Button