i have five tables like technology,client,mresource,reqform,submit requirement
i need a querry like in submitrequirement table i have a column reqid and reqid is in reqform and in reqform i have clientId there i need to display clientname not id
i tried this querry its nt working
SELECT m.CompanyName, m.Name, t.Technology, s.SubmittedOn, m.upload, s.Reqid
FROM MResource m,submitrequirement s,Technology t,Client c,Reqform r
where s.Reqid=r.Reqid and m.CompanyName=c.C_ID and t.T_ID = m.technology and r.C_ID = c.company