SingleStore DB

Can I JOIN multiple sharded tables in a query?

Yes. SingleStore DB supports advanced join capabilities and will automatically redistribute data as necessary to complete a query. SingleStore DB can also take advantage of collocated data across shard keys and reference tables to reduce data movement. See Distributed Joins.