Problem with infoset/query: Some data are missing

[Former Member]

hi all,

i created an infoset and a query with tables AGR_AGRS (composite/single roles) and AGR_TCODES (tcodes in roles)with SQ01/02.

Problem is that some roles without tcodes dont appear in the report(no data in AGR_TCODES)

I tried to change properties of joints in SQ02 (external) but it doesnt work..

Any idea? Let me know if you need further info,

julien

[Former Member]

Join you use should be Left outer Join to pick those values in AGR_AGRS. Inner join will only pick only when you have a corresponding entry in the second table.

Cheers

Sujay

[Former Member]

Join you use should be Left outer Join to pick those values in AGR_AGRS. Inner join will only pick only when you have a corresponding entry in the second table.

Cheers

Sujay

[Former Member]

Hi Sujay,

My infoset is built like this:

agr_define_____________agr_agrs___________________agr_texts

.............................................. |_______________________agr_tcodes____________________agr_texts

I tried to change agr_define_____________agr_agrs and agr_agrs_____________agr_tcodes using left inner joing but no result.

I appreciate your help,

Julien

Edited by: JULIEN LEGAL on Aug 16, 2010 9:47 AM