Scott Baker <[EMAIL PROTECTED]> wrote: > Mike McGonagle wrote: >>> -- Compound Query >>> SELECT data FROM LIST WHERE mid = (SELECT id FROM MAIN WHERE name = >>> "something") ORDER BY ord; >>> >>> -- Individual Queries >>> SELECT id FROM MAIN WHERE name = "something"; >>> SELECT data FROM LIST WHERE mid = id_as_returned_above; > > This just screams inner join. > > SELECT data FROM LIST l > INNER JOIN MAIN m ON l.mid = m.id > WHERE m.name = "something";
The two statements are not equivalent: they produce different results if there's more than one record in MAIN with name='something' Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
