Three-way full outer join in SQLite

Posted by Vince on Stack Overflow See other posts from Stack Overflow or by Vince
Published on 2010-05-26T00:49:53Z Indexed on 2010/06/03 17:24 UTC
Read the original article Hit count: 187

Filed under:
|

I have three tables with a common key field, and I need to join them on this key. Given SQLite doesn't have full outer or right joins, I've used the full outer join without right join technique on Wikipedia with much success.

But I'm curious, how would one use this technique to join three tables by a common key? What are the efficiency impacts of this (the current query takes about ten minutes)?

Thanks!

© Stack Overflow or respective owner

Related posts about database

Related posts about sqlite