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 ??
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 ??