Ralf Jantschek <[email protected]> wrote: > Thanks a lot for that. > > Considering my configuration: > > Table1: T1.id, t2.id, t1.name (, some other fields) > > Table2: T2.id, t3.id (m:n relation) > > Table3: T3.id, name, value, status (values: 0, 1, 9) > > > I still got a problem with this one: > > select * from MyTable t1 join MyTable t2 on (t1.name = t2.name) > where t1.status = 0 and t2.status = 1 and t1.value != t2.value; > > Unfortunately I forgot to mention, that there is a name field in T1 which > contains different information as t3.name. > This is the Information I have to select the Rest. Additionally the Status > field is only part of T3.
I still don't understand the problem statement. Show some sample data, and the desired result over that sample. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
