I just realized that joins in SQL in DOMO are not case sensitive! This is a huge problem for me and my team. Here's an example:
left join table_2 on table_1.manager_id = table_2.manager_id_2
Can anyone tell how to make the join case sensitive?
You can utilize the BINARY keyword to force MySql dataflow to do a case sensitive join.
left join table_2 on BINARY table_1.manager_id = table_2.manager_id_2