clarify my question

Hi Friend,

Try the following code:
<%@page import="java.sql.*"%>
<form>
Enter ID:<input type="text" name="id"><input type="submit" value="Submit" style="background-color:#49743D;font-weight:bold;color:#ffffff;">
</form>
<%String id=request.getParameter("id");
if(id!=null){
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql";, "root", "root");
Statement st=connection.createStatement();
ResultSet rs=st.executeQuery("SELECT * FROM parents where parentsID='"+id+"'");
%>
<table border="1">
<tr><th>Parents ID</th><th>Name</th><th>Contact No</th><th>Location</th><th>Tutors ID</th><th>Name</th><th>Contact No</th><th>Location</th></tr>
<%
String sub="",qua="";
while(rs.next()){
sub=rs.getString("strSub");
qua=rs.getString("strtutorType");
}
ResultSet res=st.executeQuery("SELECT * FROM parents,tutors WHERE tutors.strSubt = '"+sub+"' and tutors.strQualificationt = '"+qua+"' and parentsID='"+id+"' ");
while(res.next()){
%>
<tr><td><%=res.getString("parentsId")%></td><td><%=res.getString("name")%></td><td><%=res.getString("contactNo")%></td><td><%=res.getString("strLocation")%></td><td><%=res.getString("tutorsId")%></td><td><%=res.getString("tname")%></td><td><%=res.getString("tcontactNo")%></td><td><%=res.getString("strLocation1")%></td></tr><%
}
}
%>
</table>

Thanks

For the above code, we have created following database table:

1)parents:

CREATE TABLE `parents` (
`parentsId` bigint(255) NOT NULL auto_increment,
`strSub` varchar(255) default NULL,
`strtutorType` varchar(255) default NULL,
`strLocation` varchar(255) default NULL,
`name` varchar(255) default NULL,
`address` varchar(255) default NULL,
`contactNo` int(255) default NULL,
`email` varchar(255) default NULL,
PRIMARY KEY (`parentsId`)
)

2)tutors:

CREATE TABLE `tutors` (
`tutorsId` bigint(255) NOT NULL auto_increment,
`strQualificationt` varchar(255) default NULL,
`strLocation1` varchar(255) default NULL,
`strSubt` varchar(255) default NULL,
`tname` varchar(255) default NULL,
`taddress` varchar(255) default NULL,
`tcontactNo` int(255) default NULL,
`temail` varchar(255) default NULL,
PRIMARY KEY (`tutorsId`)
)

Hope that it will be helpful for you.
Thanks