I'm having a problem getting a particular field to display properly. There are two tables and her is the issue:
The tables are linked:
table1.original_original_vendor_id ----> table2.vendor_id (full outer join)
table1.vendor_to_send ----> table2.vendor_id (full outer join)
I'm using full outer joins because there is not always data to populate each record. Sometimes they are blank and that's okay.
The report correctly displays both table1.original_original_vendor_id and table1.vendor_to_send, but when I drop in table2.vendor_name, nothing is displayed.
How can I get the table2.vendor_name to display when it is linked to both table1.original_original_vendor_id and table1.vendor_to_send?