SELECT product.prd_id,prd_name,pdt_name ,unt_name ,prd_cost , prd_price , prd_amount , prd_minamount , prd_status , color_list.col_id
,color.col_name
,volume.vol_name , property.prt_name , property_details.prt_detail_desc
FROM Product
LEFT JOIN product_type ON (product_type.pdt_id = product.pdt_id)
LEFT JOIN unit ON (unit.unt_id = product.unt_id)
LEFT JOIN color_list ON (color_list.prd_id = product.prd_id)
LEFT JOIN color ON (color.col_id = color_list.col_id)
LEFT JOIN property_details ON (property_details.prd_id = product.prd_id)
LEFT JOIN property ON (property.prt_id = property_details.prt_id)
LEFT JOIN volume ON (volume.vol_id = property_details.vol_id)
ORDER BY product.prd_id