On 31-01-2014 17:23, Joseph L. Casale wrote:
I have three tables where table A is a left joined one to many relationship
against
two other tables. I now need to modify this to accept filtering what is returned
from table A based on one of the many rows in table B and/or C.
The row from table A is only valid with all the corresponding rows from B and C.
What is the most elegant way to accomplish this?
Thanks for any pointers,
use a 'inner join', in stead of a 'left join' ?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users