Q:

The multi part identifier could not be bound

SELECT * FROM Products_Joined, Products 
WHERE p.ProductManufacturer = 'Sony' 
ORDER BY p.ProductCode

I keep getting the error The multi part identifier p.ProductManufacturer could not be bound 
I tried:

Setting the Order By
Adding the PRODUCTS table to the FROM 

Is there something I'm missing?

A:

You should use:
SELECT p.*, pj.*
FROM dbo.Products p
INNER JOIN dbo.ProductsJoined pj ON ..... <== add your missing JOIN condition here
WHERE p.ProductManufacturer = 'Sony' 
ORDER BY p.ProductCode

First of all: never use SELECT * in your production code. 
Secondly: use the proper ANSI JOIN syntax (INNER JOIN..) to clearly show what you're joining, and on what JOIN condition (which is missing in your case - you're producing a cartesian product here.....)
Third: if you use table aliases like p. - you need to define them, too!

A:

You have no p object. You need to alias one of your tables. 
SELECT * FROM Products_Joined, Products AS p
WHERE p.ProductManufacturer = 'Sony' 
ORDER BY p.ProductCode

That will fix your immediate problem, however you should have a JOIN on your tables or else you are doing a CROSS JOIN, which is usually not preferable. An example of what it would look like is below.
SELECT * 
FROM Products_Joined
    JOIN Products AS p
        ON Products_Joined.ProductsID = p.ProductsID 
--This join is a guess on what the common column is between these two tables
--Change as necessary
WHERE p.ProductManufacturer = 'Sony' 
ORDER BY p.ProductCode

UPDATE BASED ON YOUR COMMENT
If you received the error even with a Products.ProductManufacturer, then you are probably missing the ProductManufacturer column in the Products table. I would check your schema and verify the column exists.

