B04 - join and table missing in from clause

[former_member272336]

Hi,

We have following situation, using Information Design Tool and unx universe

sql is being generated when user writes queries but missing a join in from clause.

e,g should have  5 tables and 4 joins but only 4 tables and 3 joins listed only geeting three generated.

This query only behaves this way whenever an object from a certain table is inlcuded.

I don't understand how this is possible as the other objecst selected can only be retrieved by joining to the table concerned.

e.g if we exclude the join which should be genearting in the context it shos incompatible combination of objects - this proves it should b einferring this join in the sql - when inlcude the join in the context the sql getes generated but join missing in th eform clause.

Anyone seen this before and know how to resolve.

Much appreacited.

Many Thanks

[Former Member]

Hi, It is important to make sure the join missing is not Nuetral ?

[former_member272336]

Thanks for all advice.

Join included in the context - not set to neutral.

Have tracked this down to following - a shortcut join exists in the universe - not this contextbetween two unlreated tables.

When remove this shortcut join from universe ( don't need in nay case) query bahves as expecetd.

Any reason for this with shortcut joins?

Thanks

[CdnConnection]

Philip,

     Check to make sure the join in question is part of the CONTEXT.  If you want the join to show-up it MUST part of INCLUDE.

Regards,

Ajay

[former_member193452]

Is this a self-join?

Or created on a derived table

Or had it been removed, then reinserted?  All three of these issue were resolved in SP6.

What patch level are you currently at?