hi all,
this is a little embarassing as i suspect the answer might be non-sapdb-specific and a standard SQL-problem, however it's driving me nuts and looking at the reference manual didn't help either. ok, this works: select count(distinct per_lastname) from person or select distinct per_lastname, per_firstname from person but why doesn't this work? select count(distinct per_lastname, per_firstname) from person I get a SQL -5016 Missing Delimiter. could someone please enlighten me with the correct syntax to count the number of results of a distinct expression that applies to more than one column? thanks in advance, robert _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
