Make mssql query : help me please with query:   
    **select * from sc84 as nom
    join sc319 as p
    on p.PARENTEXT = nom.id
    join sc219 as pt 
    on p.sp327 = pt.id
    join _1SCONST as c
    on c.objid=p.id**   
As a result approximately such table    
Car / price_base / 08-08-2016:13-40 / 100 /   
Car / price_base / 08-08-2016:14-40 / 150 /    
Car / price_base / 08-09-2016:13-40 / 190 /    
Car / price_super / 08-09-2016:18-40 / 210 /   
Car / price_super / 08-10-2016:13-40 / 290 /      
That is goods, types of the price of date and their value. Prompt please how      to receive the last (the actual price for each type of the price and each        goods) tried options with group but there is obviously not enough skill.     

    nom.id - PK SKU     
    pt.id - PK price type   
    p.id -PK price    
    p.parentext - parent price (sku)    
    p.sp327 - FK to price type   
    date = date column   