sql view

[jainiraj]

hi .. I am creating view in sql server 2000 as- CREATE VIEW vwSam As (select admin.*, cust.FirstName+' '+cust.LastName as CustName from adminmsgrecieved as admin,custdetails as cust where admin.AdminId='111' and cust.CustId=admin.FromCustId ) From this i am getting an error invalid object adminmsgrecieved. But when i run select query only then it works fine. what problem may be??? and what should i do? plz help me.. Thanx in adv

[smcnulty2000]

Try it without the parentheses.

_____________________________ Those who study history are doomed to watch others repeat it. -Scott M.

[_Damian S_]

Have you made a typo? Received is usually spelled with ei after the c.

Knowledge is knowing that the tomato is a fruit. Wisdom is not putting it in fruit salad!! Booger Mobile - Camp Quality esCarpade 2010

[A k ch]

Try with "dbo." or "dbname." here dbname is your data base name infront of all data base objects like tables and views hope it works

Thanks & Regards, Anil Chelasani