如何在连接查询中使用MAX() ?

I would like to create a query that gets a RECID from the RECIPT table, it's custname from the Customer table and the max of RECID on the RECIPT. But somehow this query throws an error. It started when I added max(MAX(REC.REC_Id_I) As RECID).I would like to create a query that gets a RECI