Re: What it is the best way to do this (SQL to QV)
Looks like a simple join to me.
Just create the load script and add "join" above the 2nd load (or "join(tablename)" to make is more safe). As long as the key columns have the same name (can be 1, can be multiple), Qlik will automatically take care of the rest.
The default join is an outer join. If you want left, right or inner: Just add that in front of the join.