Something strange is happening with this very simple query. The result cursor has no value in the bvalue field for any of the records. However, if I enter a value and save, it is there later. Something is wrong with the query. When I look at table2 (there may be some records table1 that do NOT exist in table2) most of the records have a value in the bvalue field, but some do not. However, when I do the query, the result table has no data in bvalue in any of the records...



>>All fields are character.
>>
>>Table1 fields:
>>
>>aid
>>aagcy
>>adescriptn
>>
>>Table2 fields:
>>
>>bidv (same value as aid in table1)
>>bname
>>bvalue
>>
>>I want to join the above two tables and do the following:
>>
>>1. Create a single record for every distinct or unique aid record in table1 whether or not a match exists in table2.
>>2. Include the fields: table1.aid, table1.aagcy, table2.bvalue
>>3. If there is no matching record in table2, then I want to populate the bvalue field in the joined cursor with an empty string value ''.
>>
>>I am stuck on a simple sql statement which amazes me. I just can't concentrate today :o( Maybe it was the only 2 hours of sleep I got last night? :o)
>
>Or:
>

>SELECT DISTINCT table1.aid, table1.aagcy, NVL(table2.bvalue,SPACE(xxxx)) AS bValue;
>       FROM Table1;
>LEFT JOIN Table2 ON Table1.aid == Table2.bidv
>