column name not found

I have a query line like ...

    SELECT * FROM Nodes, Accounts WHERE Nodes.name = 'dyn0011' AND
Nodes.id = Accounts.node_id AND Accounts.name = 'dude'

After I get my resultsets, I do a rs.getInt("Nodes.id"), but then I get
the following error ...

17:52:35,693 ERROR [ConfigAccountBean] The column name Nodes.id not
found.

My problem is that both the nodes and accounts tables have an 'id'
column, so thats why I look for "Nodes.id" in the result set.

Any help much appreciated.