On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote:
>Greetings! >imagine this data content, >c1, c1, c3 >a, 1, 2 >b, 3, 4 >c, 5, 6 >a, 9, 8 >a, 1, 9 >c, 1, 3 >I would like to get a list of all the items in c1. So, the return would be, >a, >b, >c >I know how to do it programmatically, but is there a way to get it right >from SQLite? >thanks, >josé select distinct c1 from tablename; ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------