I'm using a query to populate a Verity index the records of Table A which
has a many-to-many relationship with Table B. I want to be able to search by
a the data in a column of B. The query I'm currently using is this:
SELECT A.a_id,
A.a_text,
B.b_text
FROM A,
AB,
B
WHERE A.a_id = AB.a_id AND
AB.b_id = B.b_id
When I run the Verity search using data I would find in the 'b_text' column,
I get multiple listings of the same record in Table A if there are multiple
B records linked to it. Is there a way re-write this query so that the
Verity engine would only return unique A records? Or another solution?
Thanks
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park Computer Systems Management, Inc.
[EMAIL PROTECTED] 205 South Whiting Street
Ph: 703-823-4300 Suite 201
fax: 703-823-4301 Alexandria, VA 22304
http://www.csmi.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
