I would suggest a minor addition to the below ... where a.fieldname1= b.fieldname1
otherwise the results could be eerrr well rather large .... ( select what you want ...) Nicholson, Dale wrote: >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]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>