How do you reference col's in a join statement?
Posted on 2002-04-03
I have a join statement between two tables (actually it is a single table that has a recursive FK). How do reference the col's in the rs.getString ?? Normally I just do a rs.getString("colname") but what if the columns are the same name? I would think if you have a staff.lname and a employee.lname, then you would ref it by rs.getString("staff.lname").... but it doesn't seem to work...
I can enter the col index value rs.getString(1) and it will return the right value, but I want to reference by the name of the col....