Re: help : report 2.0

From: Les Kopari <kopari_at_garlic.com>
Date: 29 Dec 1994 00:45:54 -0800
Message-ID: <3dtt02$dfb_at_garlic.com>

S H CHUA (shchua_at_technet.sg) wrote:
: I need to print a list of customers which satisfy a condition, say
: comply_flag = 'Y'.
: To check whether the customer is to be included in the report, I need a
: program unit to determine the value of the comply_flag using cursors and
: some complicated checks against other tables. ( i just can't think of a
: single select statement to pick out customers with comply_flag='Y')
 

: How do I write the query to retrieve only customers with comply_flag='Y'?

select customer
  from customers
 where comply_flag='Y';

CUSTOMER

---

Hewlett Packard Co.
IBM
DEC
Apple
Oracle
Sybase

6 rows selected. Received on Thu Dec 29 1994 - 09:45:54 CET