troubleshooting Question

Multi-part identifier could not be bound when using SQL Left Join

Avatar of DeonM
DeonM asked on
Microsoft SQL Server 2005
2 Comments1 Solution498 ViewsLast Modified:
Id like to retrieve all Call Logs and then also their Call log actions if they got any.
I receive this error "The multi-part identifier "a.ID" could not be bound."
when running the following select query:

SELECT a.*, b.Fullname, c.*
FROM CallLogs a, Users b
LEFT JOIN CallLogActions c
   ON a.ID = c.CallLogID
	WHERE a.UserID= b.ID 
	AND a.Status = 1
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros