do this... SELECT p.name, p.firstName, p.adress, f.name as formation_name FROM person p, formation f
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:06 PM To: Struts Users Mailing List; 'Struts Users Mailing List' Subject: RE: [OT] trouble with JDBC It's still doesn't work .. I'm been using postgresql 7.3 on cygwin with the jdbc driver comming with jboss. -- Alexandre Jaquet >-- Original Message -- >Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >From: "James Mitchell" <[EMAIL PROTECTED]> >To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]> >Subject: RE: [OT] trouble with JDBC >Date: Fri, 28 Feb 2003 15:54:49 -0500 > > >Use an alias. > >Depending on the vendor you could have: >SELECT name, firstName, adress, formation.name formation_name FROM >person, formation > >Or > >SELECT name, firstName, adress, formation.name as formation_name FROM >person, formation > > >-- >James Mitchell >Web Developer/Struts Evangelist >http://jakarta.apache.org/struts/ > > > >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 28, 2003 3:49 PM >> To: Struts Users Mailing List; [EMAIL PROTECTED] >> Subject: [OT] trouble with JDBC >> >> >> Hi know this is really out of topic but I get trouble with >> query who require >> multiple tables with same column name through JDBC. >> >> Ex : >> SELECT name, firstName, adress, formation.name FROM >> person, formation >> ..... >> >> With a query like this one I got en exception : The column >> name formation.name >> not found .... >> >> But work fine in a console... >> >> Any idea ?? >> >> -- >> Alexandre Jaquet >> >> sunrise premiumsurf - ne vous contentez pas du minimum! >> http://internet.sunrise.ch/fr/internet/int_sps.asp >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > sunrise premiumsurf - ne vous contentez pas du minimum! http://internet.sunrise.ch/fr/internet/int_sps.asp --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
