PHP and SQL help

[182x]

Hey guys,

 

I have two different and unrelated tables and I have done a query to extract infor mation from it and I also have preformed a query to extract information from another table. I was wondering using PHP and my sql is it possible to perform some form of check so that if the year in table1 equals 2007 and the count is 3 and the year in table 2 is 2007 and the count is 1 so the counts can be added together and im just left with one 2007 value. So the final out put would be 2007 and 5?

 

$sql1 = "SELECT year, count(*) FROM table1 GROUP BY year";
	$query1= mysql_query($sql1, $link_id) or die(mysql_error());

$sql2 = "SELECT year, count(*) FROM table2 GROUP BY year";
	$query2= mysql_query($sql2, $link_id) or die(mysql_error());


//don't know what to do here