November 23, 2011 at 12:42 pm
i have the following query
select * from table1
left join table2 t2 on table3.k1 = t2.k1
where
g1 is null
and g2<= 0
and
g3 not in ( select g3 from table1 group by g3 having count(*) >1);
and the following is the error message
[Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "table3.k1" could not be bound.]
November 23, 2011 at 12:49 pm
and also table3 is a view
November 23, 2011 at 12:52 pm
It means pretty much what it says. You don't have a table named or aliased "table3" in your query. You can't reference a column in a table that you haven't specified in your query.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
November 23, 2011 at 12:54 pm
You can't reference table3 because it isn't in the query. Shouldn't it be table1.k1 = T2.k1
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply