joecool2005 Posted November 5, 2012 Share Posted November 5, 2012 Hi, In the following query select o.Price, t1.EnglishMessage from Products p, OrderItems o LEFT JOIN TranslateMessage t1 ON p.ProductName= t1.TranslateMessageIDwhere p.ProductID = o.ProductID and o.OrderId=62 I got the following errorThe multi-part identifier "p.ProductName" could not be bound. Sounds like it does not like when I use more than one table.Any solution? Thx Link to comment Share on other sites More sharing options...
justsomeguy Posted November 5, 2012 Share Posted November 5, 2012 Specify the type of join you want instead of using a comma to separate the tables. It sounds like that table doesn't have a ProductName column though. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now