Code Forums - View Single Post

DJMaze · 03-05-2007, 03:12 AM

Code:

SELECT SUM(price)/COUNT(*) FROM table1 WHERE full_add LIKE '%%' GROUP BY full_add
UNION SELECT SUM(price)/COUNT(*) FROM table2 WHERE full_add LIKE '%%' GROUP BY full_add

03-05-2007, 03:12 AM	#6 (permalink)
DJMaze Senior Contributor Join Date: Mar 2005 Posts: 705	Code: SELECT SUM(price)/COUNT() FROM table1 WHERE full_add LIKE '%%' GROUP BY full_add UNION SELECT SUM(price)/COUNT() FROM table2 WHERE full_add LIKE '%%' GROUP BY full_add __________________ UT: Ultra-kill... God like!