i have two table, i want this to be compile into 1 table so that i can do a Search view the information of any particulars of SCHOOL and CONTACT information.
i have a problem now.. because of Name is in School (TABLE AT THE BOTTOM) and Staff Contact table (TABLE AT THE TOP), it will result in ambiguos column name..so any example how can i create this stored procedure?
qhairy
Member
1 Points
13 Posts
help with store procedure
Jan 26, 2013 05:24 AM|LINK
i have two table, i want this to be compile into 1 table so that i can do a Search view the information of any particulars of SCHOOL and CONTACT information.
i have a problem now.. because of Name is in School (TABLE AT THE BOTTOM) and Staff Contact table (TABLE AT THE TOP), it will result in ambiguos column name..so any example how can i create this stored procedure?
kaysar98
Member
176 Points
38 Posts
Re: help with store procedure
Jan 26, 2013 05:44 AM|LINK
i think you can use LEFT JOIN
sreejukg
All-Star
27495 Points
4095 Posts
Re: help with store procedure
Jan 26, 2013 06:30 AM|LINK
You can use fully qualified name for column to give a new name for the column.Fully qualified name is tablename.columnname
My Blog
qhairy
Member
1 Points
13 Posts
Re: help with store procedure
Jan 26, 2013 06:51 AM|LINK
thanks... solved