Topic: Подскажите, как в SQL Запросе отцентровать данные
Сейчас мой запрос выглядит так, и мне надо не которые графы отцетровать.
SELECT
request."year-ident"
,strftime('%d.%m.%Y', request.data1)
,groupN.setGroup
,client.name
,tech.name
,brand.name
,request.model
,masters.name1
,request.note
,strftime('%d.%m.%Y', request.data2)
,request.warranty
,strftime('%d.%m.%Y', request.data3)
,request.id
FROM
request
LEFT OUTER JOIN client ON client.id=request.id_client
LEFT OUTER JOIN groupN ON groupN.id=client.id_groupN
LEFT OUTER JOIN tech ON tech.id=request.id_tech
LEFT OUTER JOIN brand ON brand.id=request.id_brand
LEFT OUTER JOIN masters ON masters.id=request.id_masters
WHERE
(CASE WHEN '{sqlEdit1}' = '' THEN 1=1 ELSE request."year-ident" LIKE '{sqlEdit1}%' END) OR
(CASE WHEN '{sqlEdit1}' = '' THEN 1=1 ELSE groupN.setGroup LIKE '{sqlEdit1}%' END) OR
(CASE WHEN '{sqlEdit1}' = '' THEN 1=1 ELSE client.name LIKE '{sqlEdit1}%' END) OR
(CASE WHEN '{sqlEdit1}' = '' THEN 1=1 ELSE tech.name LIKE '{sqlEdit1}%' END) OR
(CASE WHEN '{sqlEdit1}' = '' THEN 1=1 ELSE brand.name LIKE '{sqlEdit1}%' END) OR
(CASE WHEN '{sqlEdit1}' = '' THEN 1=1 ELSE request.model LIKE '{sqlEdit1}%' END) OR
(CASE WHEN '{sqlEdit1}' = '' THEN 1=1 ELSE masters.name1 LIKE '{sqlEdit1}%' END) OR
(CASE WHEN '{sqlEdit1}' = '' THEN 1=1 ELSE request.note LIKE '{sqlEdit1}%' END)