Results 1 to 2 of 2
  1. #1
    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!

  2. #2
    Join Date
    Oct 2003
    Can you post the query you used with some sample and output data?

    Failing to plan is Planning to fail

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts