subject:"\[sqlite\] sqlite\-users Digest, Vol 42, Issue 30"

Re: [sqlite] sqlite-users Digest, Vol 42, Issue 30

2011-06-30 Thread Igor Tandetnik

Pete wrote: > Thanks Igor. I assume your comment about the two queries not returning the > same results is because the LEFT JOIN query would return TableA rows with no > matching TableB rows, whereas the Scalar query would not. No - it's because the LEFT JOIN query may return more than one row f

Re: [sqlite] sqlite-users Digest, Vol 42, Issue 30

2011-06-30 Thread Pete

Thanks Igor. I assume your comment about the two queries not returning the same results is because the LEFT JOIN query would return TableA rows with no matching TableB rows, whereas the Scalar query would not. How could I change the scalar query to emulate the LEFT JOIN query? Pete -