sql server - Not able to write left outer join for same table query in MS Access database -

i have table in ma access

i retrieving data sql database query

select top (100) percent      dbo.tree.pname     ,dbo.tree.slno pnum     ,dbo.tree.pname cname     ,dbo.tree.prnt dbo.tree left outer join dbo.tree ptr_acntinfo_1 on dbo.tree.prnt = tree.slno tree.ref = 155 order dbo.tree.prnt; 

it working when retrieving sql databse(the table structure same in ms access , sql database).

when retrieving data ms access database same query showing error the select statement includes reserved word or argument name misspelled or missing, or punctuation incorrect.

i want same query ms access database. me. thank you.

try 1 (top (100) percent , think left join unnecessary) -

select       t.pname     , t.slno pnum     , t.pname cname     , t.prnt tree t --left outer join tree t2 on t.prnt = t2.slno t.ref = 155 order t.prnt