fix a solution for my expected query.
two tables (tblbranch and tblBill)
(note: each branch is having many bills)
i want all fields in tblbranch and last bill from tblBill
select a.*,b.* from tblbranch a innerjoin tblBill b on a.Bcde=b.Bcde ..... order by b.billdate desc limit 1
Actually i am requiring a query to execute in mysql db