A little confused about when to use which for a simple join by key.
given a document like this:
What is the difference between the 2 queries, and which is preferred?
select a, (select b from b use keys a.b) from a use keys 'key'
select a, b from a use keys 'key' join b on keys a.b