I have a master/detail query and want to do a full join from two tables in the detail part:
FROM REPORT R
FULL JOIN REPORT_REQUEST
ON R.KEY_VAL = REPORT_REQUEST.KEY_VAL
KeyLinksAutoDefine is checked and the KeyLinks value is
I can't seem to get the full join to work. If the MasterLinks is R.KEY_VAL=MASTER.KEY_VAL I get the entries in the REPORT table, if it is REPORT_REQUEST.KEY_VAL=MASTER.KEY_VAL I get the entries in REPORT_REQUEST table. How do I get both?