I have a query that needs to join some tables and look for matching data between two accounts. In mysqlstudio the query runs fine but in Impala it gives me errors. I am not sure why? Do I have to use left and right to mimic a full join?