Hello John, I have the following N:M relationship:
MD.ID MDV.MD MDV.MA MA.ID Now I want to know, which MD have no entry in MDV. In SQL: SELECT MD.* FROM MD LEFT OUTER JOIN MDV ON MD.ID=MDV.MD WHERE ISNULL(MDV.MD) How do I do this in Rose? Thanks, 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 Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
