runeveryday Posted July 20, 2010 Share Posted July 20, 2010 $result = mysql_query("SELECT area, agent_name, item_name, quantity, item_price, (quantity*item_price) as total FROM agents INNER JOIN sales on agents.agent_id = sales.agent_id INNER JOIN items on sales.item_id = items.item_id ORDER BY area ASC"); what about this query mean? any tips would be appreciated Quote Link to comment https://forums.phpfreaks.com/topic/208294-the-query/ Share on other sites More sharing options...
Philip Posted July 20, 2010 Share Posted July 20, 2010 What about it? Quote Link to comment https://forums.phpfreaks.com/topic/208294-the-query/#findComment-1088778 Share on other sites More sharing options...
runeveryday Posted July 21, 2010 Author Share Posted July 21, 2010 What about it? can't know about this INNER JOIN sales on agents.agent_id = sales.agent_id INNER JOIN items on sales.item_id = items.item_id Quote Link to comment https://forums.phpfreaks.com/topic/208294-the-query/#findComment-1088889 Share on other sites More sharing options...
fenway Posted July 23, 2010 Share Posted July 23, 2010 That's not english. Quote Link to comment https://forums.phpfreaks.com/topic/208294-the-query/#findComment-1090341 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.