I have a query I am trying to rewrite as efficient as possible and not clear.
SELECT x.id, x.col
FROM table_a x
EXCEPT
SELECT y.id, y.col
FROM table_b y
JOIN table_a .....
The right hand part of the except performs several joins and already duplicates
the entire query on the left hand side, this works fine none the less, but now I
need to return row ids for each record on the left and these certainly don't
match
the row ids from the right hand side. The above query would most certainly
return
every record from the lhs.
What is the most efficient way to perform this without creating further queries
that re-evaluate the same data?
Thanks,
jlc
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
