4 messages in com.mysql.lists.javaRE: How can I perform a multiple tabl...
FromSent OnAttachments
Héctor A. Abreu03 Nov 2003 20:01 
Steve Forsyth03 Nov 2003 20:06 
JR Ruggentaler03 Nov 2003 20:08 
Héctor A. Abreu04 Nov 2003 11:01 
Subject:RE: How can I perform a multiple tables query with JDBC?
From:JR Ruggentaler (jr@mpv.com)
Date:11/03/2003 08:08:36 PM
List:com.mysql.lists.java

If you use a join you can retrieve data from more than one table through JDBC for example.

select t0.first_name, t1.street from person t0, address t1 where t0.address_id = t1.address_id

J.R.

-----Original Message----- From: Héctor A. Abreu [mailto:hect@comcast.net] Sent: Monday, November 03, 2003 10:01 PM To: ja@lists.mysql.com Subject: How can I perform a multiple tables query with JDBC?

Hi, there. I need a query that gets data from several tables in a relational database. I know the MySQL SELECT statement needed for that purpose but according to my JDBC book ResultSets don't work when the SELECT statement includes more than one table.

How do I make my multiple tables query work with JDBC?

Thank you in advance for any hint or suggestion.

Regards,

Héctor.