|
|
|
|
SELECT
IdObject,
NameObject,
PhoneObject,
DescObject,
AdresObject,
PhotoObject,
MapObject,
AreaObject,
TypeObject,
EmailObject,
FaxObject,
WebObject,
AddlyObject,
TimeObject,
NameArea,
IF(NameType IS NULL, "object", NameType) AS NameType,
IF(NameURL IS NULL, "company", NameURL) AS NameURL
FROM object LEFT JOIN objecttype ON objecttype.idObjectType = object.TypeObject
LEFT JOIN area ON area.IdArea = object.AreaObject
|
Поле NameType не заполнено, пустое, но не null | |
|
|
|
|
|
|
|
для: OLi
(25.11.2013 в 02:12)
| | Было преобразовано к виду:
SELECT IdObject, NameObject, PhoneObject,
DescObject, AdresObject, PhotoObject, MapObject,
AreaObject, TypeObject, EmailObject,
FaxObject, WebObject, AddlyObject, TimeObject,
NameArea, IF(NameType = '', 'object', NameType) AS NameType,
IF(NameURL = '', 'company', NameURL) AS NameURL
FROM object LEFT JOIN objecttype ON
objecttype.idObjectType = object.TypeObject LEFT JOIN area
ON area.IdArea = object.AreaObject AND object.TypeObject =2
ORDER BY object.IdObject DESC
|
| |
|
|
|