Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 26, 2013 06:51 AM by qhairy
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?
Jan 26, 2013 05:44 AM|LINK
i think you can use LEFT JOIN
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
Jan 26, 2013 06:51 AM|LINK