Equivalent MsAccess Query

[noviceUser]

Below is the oracle query which I am trying to convert into msaccess equivalent.I am getting confused by joins guide me to the equivalent query.

select  dv.*  
 from  GC_DONATION_DETAIL_VW dv,  SJ_CATALOG.topva  opva4,  SJ_CATALOG.topva  opva6,  SJ_CATALOG.topva  opva7
 where
      opva4.ORDERPRODUCTVARIATIONUID  =  DV.OPV_ID
      AND  opva4.ATTRIBUTEKEY  =  'tributeType'
      AND  opva6.ORDERPRODUCTVARIATIONUID  =  DV.OPV_ID
      AND  opva6.ATTRIBUTEKEY  =  'multipleRecipients'
      AND  DECODE  (opva4.VALUE,  'Holiday',  DECODE  (opva6.VALUE,  NULL,  'Y',  'B'),'N')  =  'B'
      AND  opva7.ORDERPRODUCTVARIATIONUID(+)  =  dv.opv_id
      AND  opva7.ATTRIBUTEKEY(+)  =  'TADonorID'  
      AND  OPVA7.VALUE  IS  NULL
      and  DV.DATE_INSERTED  >=  sysdate  -3

[pkstormy]

Why not just do this in the query designer? You could then change the view from Design view to SQL view (upper left corner dropdown). And that would be your SQL statement with the joins.

I'm a graphical/gui type of person and always use the designer first. Otherwise I could end up spending hours creating a sql statement that I can do in a couple of minutes using the query designer.

[noviceUser]

I donot use any gui inteface.That is the biggest drawback.