enter code here SELECT * FROM employee e FULL OUTER JOIN salarydetails s ON (e.Eid=s.Eid) WHERE s.Month="January" AND e.Eid="0002" UNION SELECT * FROM salarydetails s FULL OUTER JOIN bonus b ON (s.Eid=b.Eid) WHERE b.Month="January" AND b.Eid="0002"
I have 3 tables as employee salarydetails and bonus. I'm doing a java code to load a jtable. I have to get data from 3 different tables. The query im trying to use is the above one. But it gives errors. what am i supposed to do?
Aucun commentaire:
Enregistrer un commentaire