ibobjects - RES: [IBO] FULL JOIN

Subject	RES: [IBO] FULL JOIN
Author	Luiz
Post date	2014-10-30T12:49:22Z

Hi,

IMHO, IBO is work correctly. With full join you can have null values in your result.

Maybe, play around with a union select solve your problem.

Luiz

De: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Enviada em: terça-feira, 28 de outubro de 2014 19:01
Para: IBObjects@yahoogroups.com
Assunto: [IBO] FULL JOIN

I have a master/detail query and want to do a full join from two tables in the detail part:

SELECT R.COMMENTS
     , R.REPORTID
     , REPORT_REQUEST.STATUS
     , R.REPORTNUM
FROM REPORT R
FULL JOIN REPORT_REQUEST
ON R.KEY_VAL = REPORT_REQUEST.KEY_VAL

KeyLinksAutoDefine is checked and the KeyLinks value is

R.REPORTNUM

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?

Thanks,

Bruce