Nuts, I messed up the formatting of the queries, darned Tbird. They are: (my query) > SELECT > d.guid, > (SELECT p.value FROM properties p WHERE d.guid=p.guid AND > p.name="test.foo") AS "testfoo", > (SELECT p.value FROM properties p WHERE d.guid=p.guid AND > p.name="test.moo") AS "testmoo" > FROM > documents d > WHERE > guid > 77 AND > type = 1 AND > testmoo NOT NULL AND > testfoo NOT NULL AND > (testfoo > 50 OR testmoo > 50)
(Terry's query modified) > SELECT > d.guid, > a.value AS testmoo, > b.value AS testfoo > FROM > documents d LEFT JOIN > properties a ON a.guid = d.guid LEFT JOIN > properties b ON b.guid = d.guid > WHERE > d.guid > 77 AND > d.type = 1 AND > a.name = "test.foo" AND > b.name = "test.moo" AND > (testfoo > 50 OR testmoo > 50) D'oh, etc. Alex. _______________________________________________ Bongo-devel mailing list [email protected] https://mail.gna.org/listinfo/bongo-devel
