jacob Posted November 14, 2005 Share Posted November 14, 2005 Hello everyone, I currently working on a project to show price estimation which requires me to sum a value from two tables in mysql. Ok, below are the tables and values that I have. in example, From these table, I need to get sum price value for car in table1 with price value of india in table2. What would be the mysql syntax? thank you in advance for your help. table1 follow_by price car | 500 foot | 1000 table2 location price china | 10000 india | 15000 thailand | 20000 Quote Link to comment Share on other sites More sharing options...
Cook Posted November 14, 2005 Share Posted November 14, 2005 SELECT (`table1`.`car` + `table2`.`india`) AS `price_estimation` FROM `table1`, `table2` WHERE (some condition of yours) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.