mysql> ## Using Bugzilla as an example
mysql> ## Gives list of reporters against open bugs
mysql> ## Gets data from two different tables
mysql> ## 
mysql> use bugs;
Database changed
mysql> select realname as reporter ,count(bug_id) as bugs from profiles, bugs where profiles.userid=bugs.reporter and bugs.bug_status not like 'CLOSED' and bugs.bug_status not like 'RESOLVED' and bugs.resolution not like 'FIXED' and bugs.resolution not like 'WORKSFORME' group by realname order by bugs desc, reporter;