Hi friends,
could anybody pls help me in converting below access query into oracle query .
i am not able to understand from clause here .

SELECT DISTINCT item.SCALE_ID, item.ITEM_ID, item.COMPLETE_DT, long_txt_1.LONG_TXT AS Stemtxt, long_txt.LONG_TXT, scale.SCALE_NM
FROM (((version_item INNER JOIN (version_stem_txt INNER JOIN long_txt AS long_txt_1 ON version_stem_txt.STEM_TXT_ID = long_txt_1.LONG_TXT_ID) ON version_item.QUEST_ID = version_stem_txt.QUEST_ID) 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) INNER JOIN scale ON item.SCALE_ID = scale.SCALE_ID
WHERE (((item.SCALE_ID)=[Forms]![FrmFindMatchItems]![subfrmItem].[Form]![VerScale]) AND ((item.ITEM_ID)<>[Forms]![FrmFindMatchItems]![subfrmItem].[Form]![item_id]) AND ((item.COMPLETE_DT)<>#1/1/1950#) AND ((long_txt_1.LONG_TXT) Like "*" & [Forms]![FrmFindMatchItems]![SearchTxt] & "*"));

CAN anybody let me know if i am missing anything in below mentioned query ...

i cannot execute access query as i don't have access to cross check number of records

SELECT
DISTINCT item.SCALE_ID,
item.ITEM_ID,
item.COMPLETE_DT,
long_txt_1.LONG_TXT AS Stemtxt,
long_txt.LONG_TXT,
scale.SCALE_NM
From
long_txt long_txt_1 , long_txt , item , scale , version_item , version_stem_txt
where
version_stem_txt.STEM_TXT_ID = long_txt_1.LONG_TXT_ID
and version_item.QUEST_ID = version_stem_txt.QUEST_ID
and version_item.RESP_ITEM_TXT_ID = long_txt.LONG_TXT_ID
and version_item.ITEM_ID = item.ITEM_ID
and item.SCALE_ID = scale.SCALE_ID
-- and item.SCALE_ID = &scale_id
-- and item.ITEM_ID)<> &item_id
and item.COMPLETE_DT != to_date( '1/1/1950' , 'mm/dd/yyyy')
-- and long_txt_1.LONG_TXT Like '*%*'

Thanks for your help .