For the tables described below:

    Table A (ForeignKey, Identifier, DataA) 
        : Primary Key = ForeignKey+Identifier

    Table B (ForeignKey, Identifier, Filter, DataB) 
        : Primary Key = ForeignKey+Identifier

    Table C (Identifier, Filter, DataC) 
        : Primary Key = Identifier

Desired query result:

    For ForeignKey = a single value and Filter = a single value

    Result Table R (Identifier, DataB, DataC)

    Where there is exactly one row for each Identifier in Table A, 
    even if there are no matching rows in Table B or Table C.

What is the SQL Select Statement using SQL 95 Join syntax to generate 
the desired result?