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]
