budi saleh
asked on
Sum coloumn in mysql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank everyone...appreciate the help from both of you..
On which table do you want to add these columns? On address? If so you can add the column and make it nullabe so only a few records will have this data.
Or maybe you want just get all the information together on a query for the addresses of singapore? If so you should execute a query similar to this:
SELECT Name, Address_name, Salary_1, Salary_2
FROM name n INNER JOIN address a ON n.Name_id = a.Name_id INNER JOIN salary s ON s.Name_id = n.Name_id
WHERE Address_name = 'singapore';
Hope this helps. Regards.