stellyuk
asked on
Problem with Query....
Hi there,
Simple query that I cant get to run, this is the query:
SELECT m.*, mt.restricts, b.Module
FROM mat_trnkld m, matprt_trnkld mt LEFT JOIN BOM b
ON m.PartNo = b.partnumber
WHERE m.PartNo = mt.PartNo
AND m.SubProd = '50'
and I'm getting this error:
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "m.PartNo" could not be bound.
Thanks,
Stelly
Simple query that I cant get to run, this is the query:
SELECT m.*, mt.restricts, b.Module
FROM mat_trnkld m, matprt_trnkld mt LEFT JOIN BOM b
ON m.PartNo = b.partnumber
WHERE m.PartNo = mt.PartNo
AND m.SubProd = '50'
and I'm getting this error:
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "m.PartNo" could not be bound.
Thanks,
Stelly
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.