how i do join between 2 table (1 Viewer)

yara

New member
Local time
Today, 14:07
Joined
May 30, 2008
Messages
3
hi

i have 2 tabels :
t1 have 2 columns (Sid ,Jid)
t2 have 2 columns (Sid , Sname)

i want select all dat all S name have Jid = 3


like this

select Sname from t2 where Sid = select Sid from Jid wher Jid= 3


is my query correct ??


:)
 

jal

Registered User.
Local time
Today, 14:07
Joined
Mar 30, 2007
Messages
1,709
hi

i have 2 tabels :
t1 have 2 columns (Sid ,Jid)
t2 have 2 columns (Sid , Sname)

i want select all dat all S name have Jid = 3


like this

select Sname from t2 where Sid = select Sid from Jid wher Jid= 3


is my query correct ??


:)
Maybe something like this:

select t2.* from t1, t2 where t1.Sid = t2.Sid and t2.Jid = 3
 

yara

New member
Local time
Today, 14:07
Joined
May 30, 2008
Messages
3
hi jal

thaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaanx

:)
 

Users who are viewing this thread

Top Bottom