Jump to content

Trouble with left join


joecool2005

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...