MS SQL -- The multi-part identifier "xxx" could not be bound

Databases
1

Hey,

I’m trying to run a query but it’s giving me an error of:

Msg 4104, Level 16, State 1, Line 9
The multi-part identifier “Part.PartNum” could not be bound.
Msg 4104, Level 16, State 1, Line 4
The multi-part identifier “Part.Description” could not be bound.

I’m not sure why this is coming up. I normally don’t do things in MS SQL but I had no choice for this project.


SELECT Rep.LastName,
	   Part.Description
FROM Rep
INNER JOIN Customer
	ON Rep.RepNum = Customer.RepNum
INNER JOIN OrderLine
	ON OrderLine.PartNum = Part.PartNum

Any help please!

2

you’re referencing columns of a table (Part) that isn’t mentioned in the FROM clause

the tables mentioned in the FROM clause are Rep, Customer, and OrderLine