I have a situation where I have 3 datasources in the database expert.
There is a main table which contains a complete list of data that I want ( Ive checked the query, the total number of records agree with the front end and there is no duplicates )
I have two descriptions fields which are contained in two other command query datasources.
I linked them in the database expert but it ends up excluding 425 records because there are nulls in the main table.
How do I handle these nulls? I just want no field description to come through if there isnt one... not to exclude the record entirely....