I want the 'rowid' of the view. In other words I'd like to now what row John Smith is in the view. I can do it with a view that is ordered by using count(*), but I wondered if there was a better way.
Simon Slavin wrote: > Or are you asking about the 'rowid' of the view ? I don't know whether > that's a valid idea. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users