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)
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
