sql -457 error

netters, can anyone tell me why the following sql dies with a -457 error: select tech_group, sum(net_book_units), sum(net_book_dollars), sum(net_bill_units), sum(net_bill_dollars ) from book_bill_back where book_bill_back.rowid = -1 and fiscal_date >= TODAY - 90 group by tech_group; but if i modify it to the following it works fine: select tech_group, sum(net_book_units), sum(net_book_dollars), sum(net_bill_units), sum(net_bill_dollars ) from book_bill_back where book_bill_back.rowid = -1 { and fiscal_date >= TODAY - 90 } group by tech_group; regards, +----------------------------------------------------------------------------+ | . . | | | ... ... | Bob Baskett | | ..... ..... | Software Engineer, DBA | | .. ... .. | Business Systems Integration Group | | . . . | Semiconductor Products Sector | | | Mesa, AZ | | Motorola, Inc. | | +----------------------------------------------------------------------------+ | 'connectionLESS IS MORE' -- Data Broker | +----------------------------------------------------------------------------+ | Duct tape is like the force. It has a light side, and a dark side, and | | it holds the universe together ... | | -- Carl Zwanzig | +----------------------------------------------------------------------------+