Tag: amazon-athena

How to swap the sides of a left join in SQL?

I have two tables that I would like to query, tableA has ~53_000 rows while tableB has ~530M rows. SELECT b.some_field AS field, a.* FROM…