I need to get rowid of DISTINCT records, but so far all my test fails.
I have also tried this: CREATE VIEW v1 AS SELECT DISTINCT Artist FROM trax; SELECT rowid FROM v1 but the rowid column is empty... Any help is really appreciated... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/
