Igor Tandetnik wrote:
>
> SELECT lesson_id,title,total_time, wasPurchased
> FROM lessons join purchase_data using (group_id)
> WHERE lesson_id>=$id AND group_id>=$group_id
> ORDER BY group_id,lesson_id LIMIT 0,2
>
Thank you very much indeed: I could not undestand how and where to insert
the join and I always was receiving an error.
--
View this message in context:
http://old.nabble.com/how-to-perform-join--tp33280818p33284022.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
