On 6/18/07, mla <[EMAIL PROTECTED]> wrote: > Subselect? > > SELECT count(*) > FROM ( > SELECT DISTINCT a_id, b_id > FROM a_b_map > WHERE a_id = xxx > ) s
So far, that looks like the best option to me. Can anyone think of anything better? -John ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
