SELECT * FROM Billcode_in a LEFT JOIN Billcode_place b ON a.billcode=b.billcode AND b.id=(SELECT MAX(id) FROM Billcode_place WHERE billcode=b.billcode AND place_wavehouse_id=5);
2022-02-24 02:33:12
SELECT * FROM Billcode_in a LEFT JOIN Billcode_place b ON a.billcode=b.billcode AND b.id=(SELECT MAX(id) FROM Billcode_place WHERE billcode=b.billcode AND place_wavehouse_id=5);