如何使用内部联接查询获取不同且最新的记录

I have two table named: customers and bill. customer and bill have one to many relation. Customer table contains record of customer mobileNo,bikeNo etc Bill table contain record of customer bill with bikeNo(foreign key),billdate etc. I have query for that:. cus