Thursday, August 30, 2012

Get values from 2 queries


select (a.count1/b.count2) as result from
(SELECT count(*) as count1 FROM table1) as a,
(SELECT count(*) as count2 FROM table2) as b