joining 3 tables and loadind specific data

[momofiore]

Hey guys:

I have 3 tables   FactTicket    and    FactTicketActivity   and   Applications. i would like to join between them and load from the joind data all rows exception rows  that have    IsAutoCap=1     and   Catégorie H2= 'New IT T2'   and   ActivitySDTier =  '3'

this is my script :

FactTicket:

LOAD

%TicketKey,

%CIApplicationName,

IsAutoCap

from 

[.\..\FactTicket_Data_2017.qvd]

(qvd) ;

FactTicketActivity:

LOAD

%TicketKey,

ActivitySDTier

from

[.\..\FactTicketActivities_Data_2017.qvd]

(qvd);

Applications:

LOAD

%CIApplicationName,

Catégorie H2

from

[.\..\SD\Ref_Applications.qvd]

(qvd);

left join (FactTicket)

load * resident FactTicketActivity;

left join (FactTicket)

load * resident Applications

WHERE [Catégorie H2] <> 'New IT T2' AND ActivitySDTier <> '3' AND  IsAutoCap <> '1' ;

But i got this error 

Field not found - <ActivitySDTier>

left join (FactTicket)

load * resident Applications

WHERE [Catégorie H2] <> 'New IT T2' AND ActivitySDTier <> '3' AND  IsAutoCap <> '1'

thanks guys

[momofiore]

OK. for example i have a table box with the 3 columns ActivitySDTier , IsAutoCap and  Catégorie H2.

how can i visualize all rows exception those whom have IsAutoCap=1    and  Catégorie H2= 'New IT T2'  and  ActivitySDTier =  '3'

if you can give me a scearnshut i would be so thankfull Nico