Trouble Forming Complex Multitable Query

....Record Table        Datacode Table
  ---------------      -----------------


  | RecordNum   |----->| RecordNum     |

  | RecordInfo1 |      | Datacode      |

  | RecordInfo2 |      | DatacodeInfo1 |


  |             |      | DatacodeInfo2 |


  ---------------      -----------------

I am trying to perform a query that lists all RecordNum's from the RecordNum table and DatacodeInfo from the Datacode table for a specific datacode. There are RecordNum's without matching DatacodeInfo. I have tried an outer join, but as soon as I specify a criteria from the datacode table (like Datacode = ?), the join seems to revert back to a simple join.

Can I get the outer join effect of listing all RecordNum's while somehow specifying a criteria from the 2nd table? Is there another way to do this? Received on Tue Jan 22 2002 - 04:22:41 CET