sql - Right Outer Join to Left Outer join -


i have query in sqlserver needs translated sqlite3, query uses "right outer join", problem sqlite doesn't support operator yet.

how can translate query use "left outer join" instead of "right" outer join?

select  *    p right outer join         cl right outer join         c left outer join         cc on c.idc = cc.ridc on          c.idc = c.ridcl on p.idp = c.ridp 

thanks.

ps: i'm having trouble sqlite joins precedence , associativity, don't know how may alter final result reordering tables.

in query, table c in middle. driving query.

your on conditions in strange places. guessing mean:

select  *    c left outer join         cc         on c.idc = cc.ridc left outer join         p         on p.idp = c.ridp left outer join         cl         on cl.idc = c.ridcl 

Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -