Re: 2 Queries need to combine into one

2009-11-10 Thread Robin Brady
) AND (branches.STATUSID = 31) AND ( `agentdealer`.`STATUSID` = 31 ) GROUP BY `dealer`.`FIRMID` ORDER BY `dealer`.`FIRMID` ) On Mon, Nov 9, 2009 at 10:20 PM, Robin Brady rbr...@ssb.state.tx.us wrote: I am very new to MySQL and trying to use Navicat Report Builder to format a renewal invoice

2 Queries need to combine into one

2009-11-09 Thread Robin Brady
I am very new to MySQL and trying to use Navicat Report Builder to format a renewal invoice to send to our registrants. The renewal fees are fixed for each type of registrant but the actual fee is not part of the database and must be computed as the report is generated. As far as I can tell,