PDA

View Full Version : Help with Self join needed


ohnder
11-20-2005, 10:09 PM
How do I merge this SELECT form?

$grab_totals = "SELECT idh as idt, SUM(w) as w, SUM(d) as d, SUM(l) as l, SUM(gf) as gf, SUM(ga) as ga FROM soccer
WHERE idh LIKE 'nor' AND ida LIKE 'swe' GROUP BY idt" AND
"SELECT ida as idt, SUM(l) as w, SUM(d) as d, SUM(w) as l, SUM(ga) as gf, SUM(gf) as ga FROM soccer
WHERE ida LIKE 'nor' AND idh LIKE 'swe' GROUP BY idt";

$result = @mysql_query($grab_totals);
sql_query("$result", "$error_messages[04]");