K
kissybean via AccessMonster.com
Hi All,
I have a problem doing an outer join between two tables. They are regular
access tables. I have read through all the questions and answers for the
topic and tried various things but still it will not work.
Table 1 has 205 records. I want to join with table 2 on an ID field. I have
3 criteria on table 2. I included the null clauses in various syntax's to no
avail.
Here is the query:
SELECT a.*, b.Rate
FROM [Provider Trend Rate Final] AS b RIGHT JOIN [Trend Projections - Step 1]
AS a ON b.Provider_ID = a.[Prov ID]
WHERE (((b.Product_Line)='COM') AND ((b.Type)='B') AND ((b.IP_OP)='IP')) OR (
((b.Product_Line) Is Null) AND ((b.Type) Is Null) AND ((b.IP_OP) Is Null));
This gets me 154 rows which is not correct. I want 205 rows.
Can anyone help?
Thanks!
I have a problem doing an outer join between two tables. They are regular
access tables. I have read through all the questions and answers for the
topic and tried various things but still it will not work.
Table 1 has 205 records. I want to join with table 2 on an ID field. I have
3 criteria on table 2. I included the null clauses in various syntax's to no
avail.
Here is the query:
SELECT a.*, b.Rate
FROM [Provider Trend Rate Final] AS b RIGHT JOIN [Trend Projections - Step 1]
AS a ON b.Provider_ID = a.[Prov ID]
WHERE (((b.Product_Line)='COM') AND ((b.Type)='B') AND ((b.IP_OP)='IP')) OR (
((b.Product_Line) Is Null) AND ((b.Type) Is Null) AND ((b.IP_OP) Is Null));
This gets me 154 rows which is not correct. I want 205 rows.
Can anyone help?
Thanks!