Home » RDBMS Server » Server Administration » joining 3 or more tables together
joining 3 or more tables together [message #373168] Sun, 01 April 2001 20:05 Go to next message
summer
Messages: 2
Registered: April 2001
Junior Member
how do u go about joining 3 tables together?
eg table A has pk/fk with table B
table B has pk/fk with table C
if i want to display info from table A and table C only, how do i do that?

Report message to a moderator

Re: joining 3 or more tables together [message #373173 is a reply to message #373168] Mon, 02 April 2001 08:26 Go to previous messageGo to next message
aish
Messages: 44
Registered: March 2001
Member
SELECT TABLEA.* ,TABLEC.* FROM TABLEA ,TABLEB ,TABLEC
WHERE TABLEA.COL=TABLEB.COL
AND TABLEA.COL=TABLEC.COL

Report message to a moderator

Re: joining 3 or more tables together [message #373174 is a reply to message #373168] Mon, 02 April 2001 08:28 Go to previous messageGo to next message
aish
Messages: 44
Registered: March 2001
Member
SELECT TABLEA.* ,TABLEC.* FROM TABLEA ,TABLEB ,TABLEC
WHERE TABLEA.COL=TABLEB.COL
AND TABLEA.COL=TABLEC.COL

Report message to a moderator

Re: joining 3 or more tables together [message #373184 is a reply to message #373168] Mon, 02 April 2001 20:45 Go to previous message
summer
Messages: 2
Registered: April 2001
Junior Member
thanx for your help aish

i have just found out another way where u do a sub query

eg
select cust_lname from customer
where cust_code in ( select cust_code from invoice)
where inv_number = '2001'

this is just a really short version of the tutorial question that i am supposed to do.

Report message to a moderator

Previous Topic: confused with dates
Next Topic: Oracle Applications
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 19:13:27 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.