I have a bigtable and a smalltable, with a common key field. The smalltable does not contain records for all records in the bigtable. If I LOAD (main fields) from bigtable then LEFT JOIN LOAD (extra fields) from smalltable, I get NULL values in an extra field where a record did not exist in smalltable. If I try to select blank values in an extra field in a list box, I want to include NULL values and existing blank values. Is there a simple way of doing this?
