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?