You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Paul Glezen <pg...@us.ibm.com> on 2005/08/17 02:59:42 UTC

Re: Join 2 tables with same column name (resolved)

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