This will only display products which have items with images. I think I'm going to sit back and see if there's a simpler way to achieve what I'm trying to do. Maybe I'm going about this the wrong way, or I need to make some compromises.
Thanks On Wed, Nov 10, 2010 at 3:01 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > select name, filename from products p, images im > where 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
