Why didn't you use a Join form, you'll be using less space.

Hugo Ruesga 
perotsystems® 
US  972.577.7000
MX +52 (33) 3332.3868
P Please consider the environment before printing this email

The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.






Date: Tue, 18 Aug 2009 09:34:54 -0400
From: mark.sei...@gmail.com
Subject: Query against two forms
To: arslist@ARSLIST.ORG

**
Hi Listers,
I'm looking for some guidance on doing the following:
I have 2 regular forms called ALLrecs and PROCESSEDrecs, each having fields 
like F1, F2 and F3
I'm looking to populate a third form to contain the results of a query such 
that the user can select from a list of AVAILABLE records (everything in 
ALLrecs less all the records in PROCESSEDrecs). A working SQL statement to do 
this is:


SELECT F1, F2, F3
FROM ALLrecs
WHERE (F1 NOT IN (SELECT F1, F2, F3 FROM PROCESSEDrecs))
 
Making this new AVAILABLE form a join form (inner or outer) doesn't seem to be 
giving me the results I want. Perhaps a Direct SQL or table walk on ALLrecs? 
arrgh.

This AVAILABLE data has to be updated or recreated each time the user performs 
this activity.
 
Ultimately the users selections from AVAILABLE will be further processed, then 
will update the PROCESSEDrecs form etc etc (I've got that part).


Thanks for any thoughts.
-Mark


 Win Server 2003/MS SQL 2000
 ARS 7.1 patch 6
 ITSM 7.0.03 patch 006

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_________________________________________________________________
Messenger cumple 10 años y tiene regalos para ti
www.aniversariomessenger.com.mx
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Reply via email to