Re: How can I perform a multiple tables query with JDBC? - Héctor A. Abreu - com.mysql.lists.java

4 messages in com.mysql.lists.javaRe: How can I perform a multiple tabl...

From	Sent On	Attachments
Héctor A. Abreu	03 Nov 2003 20:01
Steve Forsyth	03 Nov 2003 20:06
JR Ruggentaler	03 Nov 2003 20:08
Héctor A. Abreu	04 Nov 2003 11:01

Subject:	Re: How can I perform a multiple tables query with JDBC?
From:	Héctor A. Abreu (hect...@comcast.net)
Date:	11/04/2003 11:01:28 AM
List:	com.mysql.lists.java

Ok, ok, ok...you're right, I'm a bad reader! The book says "updatable ResultSets: The query references only a single table".

I didn't notice that they were talking about Updatable ResultSets, so regular ResultSets should do the job (I hope so).

Thank you guys!

Hector,

That would be UpdateResultSets... not regular resultsets.

Steve

From: Héctor A. Abreu <hect...@comcast.net>

To: <ja...@lists.mysql.com> Subject: How can I perform a multiple tables query with JDBC? Date: Mon, 3 Nov 2003 23:01:29 -0500

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.