Join problem

[claude69]

Hi guy, I need help cause after the insert of 2 new table in my universe and after the join creation without problem, if I take some objects of this table to do a report nevertheless the join BO consider 2 different separate select.

Select1
SELECT
CODICE,COD_ASL,DESCRIZIONE
FROM
STRUTTURE

select 2
SELECT
COD_RIF,NOME
FROM
ASL

and not

SELECT
STRUTTURE.CODICE,
STRUTTURE.COD_ASL,
STRUTTURE.DESCRIZIONE,
ASL.COD_RIF,
ASL.NOME
FROM
ASL,STRUTTURE
WHERE
ASL.COD_RIF=STRUTTURE.CODICE

 

[Sridharan]

Hi,

Check whether you had any contexts associated with the Universe previously and find out where these two tables fall. It is possible that these tables are in two different contexts.

Sri

 

[skrandel]

I agree. Clearly your ASL table does not exist in the same context as the rest. Whoever owns the universe needs to fix this for you.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com