Filter based on what? Igor Tandetnik
James <ja...@icionline.ca> wrote: > Thanks Igor, that seems to work. It's extremely slow with my real > data though. I'll have to look into that. Also, to actually filter > the products, I would have to add additional joins outside that > sub-select correct? > > On Wed, Nov 10, 2010 at 4:26 PM, Igor Tandetnik <itandet...@mvps.org> wrote: >> James <ja...@icionline.ca> wrote: >>> This will only display products which have items with images. >> >> True. Make it >> >> select name, filename from products p left join images im on im.item_id = ( >> select im2.item_id from items left join images im2 on (items.id = >> im2.item_id) >> where items.product_id = p.id and items.buyable >> order by position desc limit 1) >> order by name; >> >> Igor Tandetnik >> >> _______________________________________________ >> 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
