hello everyone, I am new to
JDBC and have some questions.
How can I use a query that uses two tables: in my database I have a table Employee and a table Works_on
EMPLOYEE has the columns FNAME LNAME SSN
WORKS_ON has the columns ESSN (refering to the SSN in employee table) PNO and HOURS
i need a query that given a certain projectnumber (PNO) i get the firstname (FNAME), last name (LNAME) and the number of hours worked on a project (HOURS) for the different employees working on that project, i tried the following query but i think it is wrong:
String query2string = "SELECT FNAME, LNAME, HOURS FROM eployee_db.works_on,employee_db.employee WHERE PNO=? AND ESSN=SSN + ORDER BY LNAME;";
thanks for your help!