Topic: Помогите с запросом
Добрый Вечер!!!! помогите с запросом!!!)))
Есть такой запрос
SELECT
DISTINCT AUTO_TB.Гос_Номер,DRAVER_TB.Позывной,
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='1' ) as "1",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='10' ) as "10",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='11' ) as "11",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='12' ) as "12",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='13' ) as "13",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='02' ) as "2",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='03' ) as "3",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='04' ) as "4",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='05' ) as "5",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='06' ) as "6",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='07' ) as "7",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='08' ) as "8",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id AND Rent.id_month ='09' ) as "9",
( SELECT TOTAL(Rent.Summa) FROM Rent WHERE Rent.id_AUTO_TB=AUTO_TB.id ) as "Itogo"
FROM AUTO_TB
left outer join DRAVER_TB on DRAVER_TB.id_AUTO_TB=AUTO_TB.id
LEFT OUTER JOIN IP ON IP.id=AUTO_TB.id_IP
LEFT OUTER JOIN Rent ON AUTO_TB.id=Rent.id_AUTO_TB
WHERE
(CASE WHEN {ComboBox1}<>-1 THEN IP.id={ComboBox1} ELSE 1=1 END) AND AUTO_TB.archived=0
Как реализовать в данном запросе следующие, если на авто работали двое то что бы они отображались в одной строке а не в разных как это есть сейчас!!!