java code for Joining Tables

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

Joining Tables

<%
Connection connection = DriverManager.getConnection(
"jdbc:odbc:data", "Steve", "password");

Statement statement = connection.createStatement();
String query = "SELECT a.fname, a.lname, titleauthor.id " +
"FROM authors JOIN titleauthor ON authors.id = titleauthor.id";

ResultSet resultset =
statement.executeQuery(query) ;
%>







<% while(resultset.next()){ %>





<% } %>

First Name	Last Name	Book ID
<%= resultset.getString(1) %>	<%= resultset.getString(2) %>	<%= resultset.getString(3) %>