09-21-05, 15:55 #1Registered User
- Join Date
- Aug 2004
Unanswered: Database expert - Join type issue?
I will overjoyed with anyone who can help me with this dilemma!
I have a property and a photos table. The photos table contains multiple photo records for each property record, each of which have a ranking of 1 - 5. My report doesn't display any fields from the photos table - only property fields - nor does it use the photos table to define criteria. I bring in the pictures from the photos table with a formula in an OLE object based on matching property IDs. The tables are set with a left outer join, property table left. This causes the property records that have multiple photos to show up once for each photo. If I modify the selection criteria to choose records where photo.imagerank = 1, the property records without photos don't show up. I assume it's becuase I've defined a selection criterial based on the photos table, causing any properties without a photo record to be tossed. I need to show all properties meeting my property table criteria while cutting out record duplication caused by there being multiple photos for each property, while displaying the photo from the photos table which is ranked as 1.
Thanks very much!
10-04-05, 11:26 #2Registered User
- Join Date
- Oct 2003
Can you post the query you used with some sample and output data?Madhivanan
Failing to plan is Planning to fail