It sometimes would be very useful if you could do a SELECT DISTINCT, but ignoring the data in one (or maybe more) particular column. So for example
col1 col2 col3 ----------------- A B C A D C Then doing SELECT DISTINCT (IGNORE col2) * from table would produce: A B C It wouldn't matter for me if it produced the above or A D C But there could be rules/logic to that. Is this possible in SQLite or would it be possible to add this as a new option? RBS ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
