help

  • Thread starter Thread starter IrishManInUsa
  • Start date Start date
I

IrishManInUsa

SELECT EverXstores.[Cust Code], EverXstores.[Store Code], Allcust.[Store
Name], Allcust.[Store Add1], Allcust.[Store Add2], Allcust.[Store City],
Allcust.[Store State], Allcust.[Store Zip]
FROM Allcust RIGHT JOIN EverXstores ON (Allcust.[Cust Code] =
EverXstores.[Cust Code]) AND (Allcust.[Store Code] = EverXstores.[Store
Code]);


This is a query I am running.......the problem is the first two columns
display data....but the rest of the columns in the query doesn't display
data. May be it is late.....and I am not quite seeing where the problem
is....but why am I not getting any data for the last three or four
columns....it is anything from the AllCust table.....any help would be
appreciated....thanks in advance.

JD
 
This is a query I am running.......the problem is the first two columns
display data....but the rest of the columns in the query doesn't display
data. May be it is late.....and I am not quite seeing where the problem
is....but why am I not getting any data for the last three or four
columns....it is anything from the AllCust table.....any help would be
appreciated....thanks in advance.
Click to expand...

Presumably because a) there are no records in AllCust that match the
records in your other table and b) using a Right Outer Join will
display NULLS for those records.
 
I would have thought that as well....but I check the database tables.....and
did some other queries to see if there was a match....and I did find some
matches
 
I would have thought that as well....but I check the database tables.....and
did some other queries to see if there was a match....and I did find some
matches
Click to expand...

All I can suggest is that you look at the values of [CustCode] and
[StoreCode] in the records which are turning up no matches, and
doublecheck that there are records in [AllCust] for that particular
combination of fields. They must match exactly on both fields, of
course. If they do match, and they're not turning up, it's odd! Are
you sure you don't have a Filter set as well?
 
Back
Top