Last post Jan 03, 2013 11:18 PM by kevinstone
Jan 03, 2013 11:10 PM|kengkit|LINK
Dear all, based on my understanding.
1) The purpose of create VIEW is to expetide query result right? (speed of result returned) what else?
2) How can i handle duplicate column name 'customer_id'
CREATE VIEW view_customer AS SELECT * FROM customer_master cm INNER JOIN customer_personal_profile cpp ON cm.customer_id = cpp.customer_id
Jan 03, 2013 11:18 PM|kevinstone|LINK
if duplicate the column name, you might manually to rename it.
select a.aaa as NameA, b.aaa as NameB from a inner join b on a.id=b.id