I have Sql Join query for Multiple tables.
SELECT a.fourbnumber,a.fourbdate,a.taxcollector,b.cashcheque,c.propertycode
from tbl_rphead a
inner join tbl_rpdetail b on a.rpid = b.rpid
inner join tbl_assessmregister c on b.assessmid = c.assessmid
I can execute that query in Sql Editor with fast manner(3 secs only). When I excute that query using JAVA(JDBC), it doesnt returns any results and no exceptions I dont know how to fix that problem. Please Help me Note: Each table having 2 lacs records
Aucun commentaire:
Enregistrer un commentaire