P Kishor wrote: > Given a specific user_id (say, user_id = 1) how on earth do I get the > following? > idea_id idea created_by_name rating > ---------- ----------- --------------- ---------- > 1 free coffee jim 100 > 2 long breaks jim 100 > 3 quit early joe NULL
Describe in plain English precisely what you are trying to achieve. It's not obvious to me what question this resultset is the answer for. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
