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