SQL Server, a LEFT join can not only join a table, it can also be a result set

SELECT  Ma.name as Makename,        m.id as ModelID, m.name as ModelName, m.warranty as        modelwarranty,        s.i D,S.NAME,S.STYLEWARRANTYFROM dbo. Model Minner JOIN dbo. Make Ma on Ma. Id = M.makeidleft JOIN (select    row_number () over (PARTITION by S1. ModelID ORDER by S1.updatetime DESC) rowID,                            S1. Id,s1.name,s1. Modelid,v.value.value (' (value/input/content) [1] ', ' varchar ') as Stylewarranty from      dbo. Style S1                            INNER JOIN dbo. Stylepropertyvalue V on S1. Id = V.styleid                    where V.propertyid = 398                ) A        where   rowid = 1) S on S.modelid=m.idwhere m.isenabled=1 A ND m.isremoved=0