select company, item
from companies, items
where companies.company = items.company
and companies.private = 'NO'
and items.item = 600
i think..
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 31, 2000 11:06 PM
To: [EMAIL PROTECTED]
Subject: Query Question
Hi All,
I am having a heck of a time conceptualizing this query.
I basically have two tables I am working with one is a Company Database
with beside address and contact have a check box field that is labeled
PRIVATE (YES/NO).
I also have a database of records that have an items of which there may
be duplicates from several companies.
item desc company
500 item1 com1
600 item2 com1
600 item3 com3
600 item4 com4
If the company record is marked as private. Then when I select all with
a value of 600, How do I except records where the company record has
private="yes"
Find all records in database with a value of 600 except those from a
company
that is marked PRIVATE
Kelly
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
