|
balaram19
Starting Member
India
9 Posts |
 Posted - 02/22/2012 : 02:00:08
|
Hi,
Iam new to sql server, trying to join the two tables student and marks
student table has columns (stu_id,stu_name,stu_address), marks table colums are (stu_id,sub1,sub2,sub3)
when I'm trying to execute the following query Iam getting error like below.. can you gimme suggetion to recover from this.
Query:
select s.stu_name,m.sub1 from marks
left outer join student on m.stu_id=s.stu_id
Result:
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "m.stu_id" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "s.stu_id" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "s.stu_name" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "m.sub1" could not be bound.
ivbalaram |
|
error in joining tables
