Re: [sqlite] Comparing Value of a Table and creating a Delta Report

[Ralf Jantschek]

Hi,

ok I give it a try ( I just recognized, I made a mistake with the status,
this is the correct version).

Table 1            t1.id,       t1.name,        t1.status:
                        1               "Program 1"     1
                        2               "Program 1"     0

Table 2                 t1.id,  t3.id:
                        1               1
                        1               2
                        2               3
                        2               4

Table 3         t3.id,  t3.key,         t3.value
                        1               "Key 1"         "Value 1"
                        2               "Key 2"         "Value 2"
                        3               "Key 1"         "Value 3"
                        4               "Key 2"         "Value 2"

What do I have to do, to find out that "Key 1" got a new value?

I hope this helps to clarify.

Thanks
Ralf

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users