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 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? 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 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. Link to comment https://forums.phpfreaks.com/topic/208294-the-query/#findComment-1090341 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.