468,161 Members | 1,946 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,161 developers. It's quick & easy.

limit records in left table but all records in right table

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

Jul 7 '06 #1
1 1598
"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

Jul 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by SteveJ | last post: by
1 post views Thread by Ian Davies | last post: by
1 post views Thread by gcdp | last post: by
reply views Thread by kamranasdasdas | last post: by
reply views Thread by gcreed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.