I
Ian
Can anyone explain this problem, which appears unique to
Win98? I created a query based on another query, from
which I want to include all records, and a table from
which I want only matching records.
I linked the query and table with an outer join based on
two fields. The result however doesn't give all the
records from the query, but rather only those that have a
match in the joined table - as though i'd used an inner
join.
If I create a table from the first query and then use that
as the basis of the outer join in the second query, I get
the correct records returned.
This only happens in Win98 when I have an outer join based
on 2 (or possibly more) fields - it doesn't happen if I
link only a single field (it may also happen with NT4,
though that was reported 2nd hand to me). In either
version of XP, or Win2000, the query gives the correct
results regardless of whether it is a query or a table
that is on the 'left' side of the Left Outer join.
I've tested this on quite a few computers and it happens
each time. The worrying thing is that there is no error
message or anything to alert you that only partial results
are being returned. Any ideas??
Thanks
Ian
Win98? I created a query based on another query, from
which I want to include all records, and a table from
which I want only matching records.
I linked the query and table with an outer join based on
two fields. The result however doesn't give all the
records from the query, but rather only those that have a
match in the joined table - as though i'd used an inner
join.
If I create a table from the first query and then use that
as the basis of the outer join in the second query, I get
the correct records returned.
This only happens in Win98 when I have an outer join based
on 2 (or possibly more) fields - it doesn't happen if I
link only a single field (it may also happen with NT4,
though that was reported 2nd hand to me). In either
version of XP, or Win2000, the query gives the correct
results regardless of whether it is a query or a table
that is on the 'left' side of the Left Outer join.
I've tested this on quite a few computers and it happens
each time. The worrying thing is that there is no error
message or anything to alert you that only partial results
are being returned. Any ideas??
Thanks
Ian