Select cast(0 as int) pseudoid, id, <все другие нужные столбцы> from t1 where status <> 1
Union
Select cast(0 as int) pseudoid, id, <все другие нужные столбцы> from t2 where status <> 1
Union
-- теперь самый фокус
Select id, 0, <все другие нужные столбцы> from t1 where status = 1Select * from table1
order by cast(field1 as varchar(5))+field2Select
comments.post, comments.id, comments.parent_id, comments.name,
Cast(0 as integer) as ban, cast('' as varchar(200) as adm
from comments where comments.post LIKE '$docid'
UNION
select cast('' as varchar(250)), 0 , 0, '', ban, adm from dell where dell.adm LIKE '$adm'select * from mytable where myfield like '%SOMETHING' -- ищет чтоб SOMETHING было в конце
select * from mytable where myfield like '%SOMETHING%' -- ищет в нутри с любой позиции
select * from mytable where myfield like 'SOMETHING%' -- ищет сначала.select
m.date,
(select sum(kolichestvo) from mytable p where p.produkt='Отруби' and p.date=m.date) as OTRUBI,
(select sum(kolichestvo) from mytable p where p.produkt='Перья' and p.date=m.date) as PERIA,
(select sum(kolichestvo) from mytable p where p.produkt='Пшено' and p.date=m.date) as PSHENO,
(select sum(kolichestvo) from mytable p where p.produkt='Картон' and p.date=m.date) as Karton,
(select sum(kolichestvo) from mytable p where p.produkt='Кирпич' and p.date=m.date) as KIRPICH
from mytable m
group by m.date
order by m.dateselect shifr, size, unit from table1 where param1=:param
union
select shifr, size, unit from table2 where param1=:param