How to make a FLAG appear?

From: <dolans_at_my-deja.com>
Date: Mon, 04 Oct 1999 19:04:44 GMT
Message-ID: <7tato0$f9b$1@nnrp1.deja.com>

I have two tables A and B where I want to return the data from A and a FLAG of a 0 or 1 from table B only IF there exists something in B. The reason is that table B is of LONG data and I don't want to return it unitl the user chooses to view it, so I want a button that appears if the FLAG is true. How do you do it? Here is my query that almost works below:

    SELECT ALL a.DATE_START, a.DATE_FINISH,     b.DESCR
    FROM tableA a, tableB b
    WHERE a.EVENT_ID=1
     AND (b.EVENT_ID(+)=a.EVENT_ID);

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 04 1999 - 14:04:44 CDT