[SQL] Outer join construction step :strange results

2010-06-28 Thread ced
Dear members of the list. I've tried to summarise my problem in a synthetic manner. Stripping non necessary columns (they only contain data about the row no relational stuff). Giving general names to the tables. I have table following tables T0,T1,T2,T3, T1T2 with -T0(id, fk_T1) -T1(id ) -T2(id,

Re: [SQL] Outer join construction step :strange results

2010-06-28 Thread Oliveiros d'Azevedo Cristina
Howdy, Cedric . Before analysing this problem of yours further, I 'd like you to kindly clarify me some points, please I have table following tables T0,T1,T2,T3, T1T2 with -T0(id, fk_T1) -T1(id ) -T2(id, fk_T3) -T1T2(fk_T1,fk_T2) -T3 (id) The table T0 represents sets of T1 items. The tab

Re: [SQL] Outer join construction step :strange results

2010-06-28 Thread ced
Oliveiros d'Azevedo Cristina wrote: > Howdy, Cedric . > > Before analysing this problem of yours further, I 'd like you to > kindly clarify me some points, please > > > >> >> I have table following tables T0,T1,T2,T3, T1T2 >> with >> -T0(id, fk_T1) >> -T1(id ) >> -T2(id, fk_T3) >> -T1T2(fk_T1,fk_T

Re: [SQL] Outer join construction step :strange results

2010-06-28 Thread Oliveiros d'Azevedo Cristina
Oliveiros d'Azevedo Cristina wrote: Howdy, Cedric . Before analysing this problem of yours further, I 'd like you to kindly clarify me some points, please I have table following tables T0,T1,T2,T3, T1T2 with -T0(id, fk_T1) -T1(id ) -T2(id, fk_T3) -T1T2(fk_T1,fk_T2) -T3 (id) The table T

Re: [SQL] Outer join construction step :strange results

2010-06-28 Thread ced
Oliveiros d'Azevedo Cristina wrote: > > >> Oliveiros d'Azevedo Cristina wrote: >>> Howdy, Cedric . >>> >>> Before analysing this problem of yours further, I 'd like you to >>> kindly clarify me some points, please >>> >>> >>> I have table following tables T0,T1,T2,T3, T1T2 with

Re: [SQL] Outer join construction step :strange results

2010-06-28 Thread Oliveiros d'Azevedo Cristina
Can you specify a little more how you represent T1 item sets with this data model? (T0.id,T0.fk_T1)=(1,234),(1,235),(1,236) 234,235,236 all T1 items and 1 the set of them What exactly represents one row from table T0? A pair (id, fk_T1) ? A set with just one element? one item in the set. Th

Re: [SQL] Outer join construction step :strange results

2010-06-28 Thread ced
You are right, this is not a correct description. I'll just in the process of creating a test db to clarify my point and to produce the symptom. It'ill me take me some more time, give me an hour or so thks cedric Oliveiros d'Azevedo Cristina wrote: > >>> Can you specify a little more how you