Thanks, Eric. That worked.
What error are you getting? Did you try updating your query to reference a.id and b.id by aliases? This should work.
select a.id as id1, b.id as id2, b.company
from prod a, prod_loc b
where a.id = b.company
What error are you getting? Did you try updating your query to reference a.id and b.id by aliases? This should work.
select a.id as id1, b.id as id2, b.company
from prod a, prod_loc b
where a.id = b.company
