Hi dave,

sorry for not formatting code in the first place ..

pls find formatted code ...
if i am missing anything while converting to oracle sql

MS Access generated Code :
--------------------------
Code:
SELECT 
       DISTINCT item.SCALE_ID, 
       item.ITEM_ID, 
       item.COMPLETE_DT, 
       long_txt.LONG_TXT, 
       scale.SCALE_NM, 
       long_txt_1.LONG_TXT
FROM 
       scale INNER JOIN (((version_item INNER JOIN long_txt 
             ON version_item.RESP_ITEM_TXT_ID = long_txt.LONG_TXT_ID) 
             INNER JOIN item 
             ON version_item.ITEM_ID = item.ITEM_ID) 
             LEFT JOIN (long_txt AS long_txt_1 
             RIGHT JOIN version_stem_txt
             ON long_txt_1.LONG_TXT_ID=version_stem_txt.STEM_TXT_ID) 
             ON version_item.QUEST_ID = version_stem_txt.QUEST_ID) 
             ON scale.SCALE_ID = item.SCALE_ID
WHERE 
             (((item.SCALE_ID)=[Forms]![FrmFindMatchItems]!    
              [subfrmItem].[Form]![VerScale]) 
              AND ((item.COMPLETE_DT)>#1/1/1950#) 
             AND ((long_txt.LONG_TXT) Like "*" & 
  	     [Forms]![FrmFindMatchItems]![SearchTxt] & "*"));
oracle code :
-------------

Code:
CREATE OR REPLACE VIEW QRYMATCHITEMS_VW 
    ( SCALE_ID, ITEM_ID, COMPLETE_DT, LONG_TXT, SCALE_NM, 
     STEM_TXT ) 
AS SELECT  
     DISTINCT item.SCALE_ID,  
     item.ITEM_ID,  
     item.COMPLETE_DT,  
     long_txt.LONG_TXT,  
     scale.SCALE_NM,  
     long_txt_1.LONG_TXT as stem_txt  
FROM 
     scale , version_item , long_txt , item , long_txt long_txt_1 ,  
     version_stem_txt  
where  
     version_item.RESP_ITEM_TXT_ID = long_txt.LONG_TXT_ID  
     and version_item.ITEM_ID = item.ITEM_ID  
     and  long_txt_1.LONG_TXT_ID = version_stem_txt.STEM_TXT_ID  
     and  version_item.QUEST_ID = version_stem_txt.QUEST_ID  
     and  scale.SCALE_ID = item.SCALE_ID  
     AND item.COMPLETE_DT > to_date(  '1/1/1950' , 'mm/dd/yyyy')
please advise if i am missing outer joins etc ...