limit records in left table but all records in right table

[aaron.reese]

Guys,

this is my problem:-

I have records which are linked by two fields on a left inner join
(there may be 0,1 or more records in the right hand table)

The relationship is not unique (it's a map reference so it can't be...)
so I am getting a cartesian join on the right hand table - look, it's
not my database OK, I don't have any choice!!!

I need to find and limit the query to the first record in the left hand
table (search criteria are on the left hand table) and then report on
all the records, if there are any, in the right hand table.

The query limit doesn't work becuase I don't know how many right hand
records there will be.

obiron

[Bob Quintal]

"aa*********@tiscali.co.uk" <aa*********@tiscali.co.ukwrote in
news:11**********************@m73g2000cwd.googlegr oups.com:

Guys,

this is my problem:-

I have records which are linked by two fields on a left inner
join (there may be 0,1 or more records in the right hand
table)

The relationship is not unique (it's a map reference so it
can't be...) so I am getting a cartesian join on the right
hand table - look, it's not my database OK, I don't have any
choice!!!

I need to find and limit the query to the first record in the
left hand table (search criteria are on the left hand table)
and then report on all the records, if there are any, in the
right hand table.

The query limit doesn't work becuase I don't know how many
right hand records there will be.

obiron

Build a query on just the left table that returns unique values,
then join the query to the right table.

You might want instead to build a form/subform or report/subreport
to show the data.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com