JOIN finder ikke den senest anmeldelse ved brug af MAX()
HejsaJeg bruger nedenstående kode, til at finde en clients totale forhold i havnen, linien ' LEFT JOIN boatreg R on (R.Client = P.Client AND R.Berth = P.Berth)'+ returnere ikke seneste boatreg.
Jeg har rodet en del med MAX(Bid), Hvor Bid er id for boatreg.
Hvad gør jeg forkert
'SELECT P.Client, P.Berth, P.Width, P.Length, P.Depth, R.Boat, R.Name, R.Bid, B.Width AS Bwidth, B.Length AS Blength, '+
' F.Fdate, F.Tdate, S.Berth, S.Id, L.Contract, L.Client AS LClient, L.Rentaltype, L.Cost, L.Fdate AS LFdate, '+
' L.Tdate AS LTdate, C.text, C.Cost FROM berth P'+
' LEFT JOIN boatreg R on (R.Client = P.Client AND R.Berth = P.Berth)'+
' LEFT JOIN boats B on (B.Boat = R.Boat)'+
' LEFT JOIN frental F on (F.Berth = P.Berth)'+
' LEFT JOIN salelist S on (S.Berth = P.Berth)'+
' LEFT JOIN rental L on (L.Berth = P.Berth)'+
' LEFT JOIN rentalcost C on (C.Rtype = L.Rentaltype)'+
' WHERE (P.Client = :Client)'+
' GROUP BY R.Berth '+
' ORDER BY R.Berth ';