Outer join problem

[Anonymous]

Hi All

Thanking you all for your valuable time.

In my report I am joing two tables by OUTER JOIN and still I am missing some records.

I have key on both table as under

Upper(date(COB_DATE,'DD-MMM-YY')) & '-' & LE_ID & '-' & Text(LOB_ID) & '-' & Text(UBR_ID) & '-' & Text(SUB_UBR_ID) & '-' & SHEET_ID & '-' & Text(LINE_NUMBER) As JUMP_OFF_KEY

TableB has records for above key, but no records exist on TableA

I have used

TableA:

  all records with JUMP_OFF_KEY;

Outer Join(TableA)

TableB:

all records with JUMP_OFF_KEY

Any idea why I am still missing records which already exists in TableB.

Thanking you

[prieper]

You may check manually the non-joined values and find the problem. Without having some data / examples available, it may be worth to check the spelling of the individual components:

Is the data really a date or a timestamp?

All text-entries follow the same logic (upper/lower case)

Why are ID's or line-number formatted as text? what about leading zeros?

HTH Peter