Hello,
I've got s.th. like this
T1.id, t2.id(, some other fields)
T2.id, t3.id (m:n relation)
T3.id, name, value, status (values: 0, 1, 9)
What I'm trying to do is the following:
I have to compare entries with status=0 to status=1 and find out the
differences in name, value fields.
- are there name entries with Status=0 that are not there with
Status=1
- are there name entries with Status=0 that have a different value
under Status=1
- are there name entries with Status=1 that are not there with
Status=0
I hope I made myself clear...
Is there anybody who can help me with the necessary Select Statements?
Thanks a lot
Ralf
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
