left join four tables

28 Posts

vasenin26 Reply #1, 13 years, 6 months ago

I have a table schema:

/*
simplified SQL code
*/
create table assocc(
    obj_id int,
    doc_id int
)

create table obj(
    id int,
    data mixed
)

create table option(
    id int,
    obj_id int,
    data mixed
)

i need build this query:

select * from modResource leftJoin assocc no assocc.doc_is = modResource.id left join obj on assocc.obj_id = obj.id left join option on obj.id = option.obj_id

XPDO can do it, or should I do it by hand only