Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Working with the SQL interface

2 posts in PB Infomaker Report Writer Last posting was on 1998-08-04 16:20:36.0Z
mwiz Posted on 1998-08-03 00:33:27.0Z
Newsgroups: sybase.public.infomaker.general
Date: Sun, 02 Aug 1998 19:33:27 -0500
From: mwiz <mwiz@ns.vvm.com>
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
Subject: Working with the SQL interface
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 10
Message-ID: <348_35C50557.D6E492A1@ns.vvm.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6963
Article PK: 242993

How can I create a query using the Infomaker interface that will display
the inverse of a query. For instance I have a customer table and a
order table. I can query all customers that have purchased products but
would like just the opposite of that. I would like to know who has not
made any purchases. Please email if possible..

TIA
mwiz@ns.vvm.com


Terry Dykstra [TeamPS] Posted on 1998-08-04 16:20:36.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Working with the SQL interface
Date: Tue, 4 Aug 1998 10:20:36 -0600
Lines: 24
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_pTEzko7v9GA.133@forums.powersoft.com>
References: <348_35C50557.D6E492A1@ns.vvm.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6962
Article PK: 242994

select cust_id from customer
where cust_id not in (select cust_id from orders)

You can build this in the graphical query painter. In the Where clause you
can right-click and choose a sub-select.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
See you at the Powersoft Conference in L.A.
http://www.sybase.com/Events/psuc98/index.html

mwiz wrote in message <35C50557.D6E492A1@ns.vvm.com>...
>How can I create a query using the Infomaker interface that will display
>the inverse of a query. For instance I have a customer table and a
>order table. I can query all customers that have purchased products but
>would like just the opposite of that. I would like to know who has not
>made any purchases. Please email if possible..
>
>TIA
>mwiz@ns.vvm.com
>