RE: Internal Select statements using IN and NOT IN

2002-05-22 Thread Alan Coleman
Never mind, I figured it out by reading a previous question and I understand how to use Left join to do this. -Original Message- From: Alan Coleman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 5:22 AM To: [EMAIL PROTECTED] Subject: Internal Select statements using IN and

Internal Select statements using IN and NOT IN

2002-05-22 Thread Alan Coleman
d then some. But I've searched the documentation and haven't found anything. If anyone knows a way to perform an internal select similar to what is shown above, please let me know. --- Alan Coleman [EMAIL PROTECTED] -