Try something like this: select a.fieldname1, b.fieldname1 from table1 a, table2 b
Where you put the a after the first table name and the b after the second table name. Then you refer to the fieldnames with those letters first so sql knows which table to look in for that field. Dale Nicholson > -----Original Message----- > From: Lee Chin Khiong [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 10, 2002 1:43 AM > To: 'Tomcat Users List' > Subject: RE: Please help me on a question about TOMCAT OR APACHE + > TOMCAT > > > > Anybody familiar with sql ? > I have a question here, how to link 2 tables from JSP when > they have a same > field name ? > > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>