AH
Ребята, помогите с запросом.. не понимаю на что именно ругается по синтаксису -
SELECT
SELECT
var.Id as ID, c.Id as COLOR_ID, p.Id as PROC_ID, IF( c.FullName != '', c.FullName, c.Name ) as COLOR_NAME, IF( p.FullName != '', p.FullName, p.Name ) as PROC_NAME FROM used_disccp_variant var LEFT JOIN used_disccolor c ON var.Color=c.Id LEFT JOIN used_discprocessway p ON var.Processway=p.Id WHERE var.CompanyId = '235'SELECTЧто за
var.Id AS ID,
c.Id AS COLOR_ID,
p.Id AS PROC_ID,
IF(
c.FullName != '',
c.FullName,
c.Name
) AS COLOR_NAME,
IF(
p.FullName != '',
p.FullName,
p.Name
) AS PROC_NAME
FROM
used_disccp_variant var
LEFT JOIN used_disccolor c
ON var.Color = c.Id
LEFT JOIN used_discprocessway p
ON var.Processway = p.Id
WHERE var.CompanyId = '235'
used_disccp_variant var ?Надо писать
used_disccp_variant as var ?