Easier said than done. The public CVS is several hours behind. Even now
Now it's there.
And works fine.
This is the SQL:
SELECT DISTINCT
t1.ID AS t1_ID
FROM
MD t1
LEFT OUTER JOIN MDV t2 ON(t1.ID = t2.MD)
WHERE
t2.MD IS NULL AND
((t1.ID = t2.MD) OR (t2.MD IS NULL))
The last line is not neccessary. Does it come from the 'with_objects'?
But is it there really neccessary? I mean the outer join guaranties that
either t1.ID = t2.MD (the join condition) or t2.MD IS NULL (condition
not met, t2 filled with NULLs).
Bye, Uwe
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
