Is this the correct syntax to return records only if there are rows of data in the table?
select * from component where exists (select * from component where category='natural') What I'm trying to do is load data into a GUI widget only if it exists. Is is more parsimonious to use only the second 'select' and assume that no records means nothing to be displayed? Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc.(TM) | Accelerator <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------