I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

November Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Forms Topic   Print This     

HowTo: Search for records not in another table

HowTo: Search for records not in another table in Paradox Forms topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: records   another   HowTo Search   HowTo Search records   not another  
juan@pcexperts.com
IT Impact
Chicago, IL USA
I need to create a query using the QBE that will list all records from table A not in table B. (A not-in query)

Thanks
 Posted 19 years ago (Thread Starter)
Comment Quote
About juan@pcexperts.com -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #1453, 4 replies
Thread Started 3/20/2001 12:46:00 PM
View Counter=2731
Last Reply Posted 5/26/2020 11:32:13 PM)
Location=Chicago, IL USA 
Joined=20 years ago   MB Posts=14   KB Posts=3  
juan@pcexperts.com
IT Impact
Chicago, IL USA
Thanks it worked. But now I would like to delete the records not in. When I use DELETE in the QBE I get an empty table. What must I do?

Regards
Juan
 Posted 19 years ago (Thread Starter)
Comment Quote
About juan@pcexperts.com -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #1484 (Level 1.1)  Reply to 1453
Thread Started 3/22/2001 8:00:00 AM
View Counter=2
Location=Chicago, IL USA 
Joined=20 years ago   MB Posts=14   KB Posts=3  
juan@pcexperts.com
IT Impact
Chicago, IL USA
I'm sorry I did not elaborate, the empty table I'm referring to is DELETED, therefore the records were not deleted.
 Posted 19 years ago (Thread Starter)
Comment Quote
About juan@pcexperts.com -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #1485 (Level 1.2)  Reply to 1453
Reply Posted 3/22/2001 8:01:00 AM
Location=Chicago, IL USA 
Joined=20 years ago   MB Posts=14   KB Posts=3  
Joe Ng
-- USA
What is in table A, not in Table B

Q=Query

A | Customer # | Customer Name |
| Check _a! | Check |


B | Customer # |
| _a,Count=0 |


EndQuery


Joe
 Posted 19 years ago
Comment Quote
About Joe Ng -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #1462 (Level 1.3)  Reply to 1453
Reply Posted 3/21/2001 8:54:00 AM
Location=-- USA 
Joined=19 years ago   MB Posts=80  
Most Recent Post
Joe Ng
-- USA
The quickest way is to take the answer table and delete "not-in" records from table A
 Posted 19 years ago
Comment Quote
About Joe Ng -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #1491 (Level 1.4)  Reply to 1453
Reply Posted 3/22/2001 9:08:00 AM
Location=-- USA 
Joined=19 years ago   MB Posts=80  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1232A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #1453 Counter
2731
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech