How do I get results from multiple tables at once?

[To advertise Java(tm) Events here, contact joris@esus.com!]

Java™
by example!

	Login
	Login here Become a member only $14.95/year!

	New @ Esus.com
	In-house search engine for better results! Get updates with the esus.com newsletter!

Home

Browse Categories

Ask a Java Question

Help

For Java Tips & Tricks, subscribe to the esus.com newsletter!

Search Java Q&A, Links, API's: adv

Index:Java 2 Enterprise Edition (J2EE):JDBC

Printer-friendly version

How do I get results from multiple tables at once?

You can do a join between tables.

This example assumes that you have set up the table orders and customers from this answer. orders looks like this:

This code sample is only viewable to esus.com members Login or become a member!

Main.java:

This code sample is only viewable to esus.com members Login or become a member!

outputs:

This code sample is only viewable to esus.com members Login or become a member!

Further Information

Author of answer: Joris Van den Bogaert

Comments to this answer are only viewable by members. Login or become a member!