query problem in sql server 2005

Posted by Suneel161 under Sql Server on 7/15/2010 | Views : 1169 | Status : [Member] | Replies : 1
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




Responses

Posted by: PandianS on: 7/15/2010 [Member] [MVP] Silver

Up
0
Down
Hi

Can you please give you Tables' structure (TableName, ColumnName, DataTYpe) ?

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Suneel161, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response