Hi,
I would like to append 2 simple query's result but they are ordered
completly different like :
select * from foo order by col1 asc
union
select * from foo2 order by col2 desc
how could I do this? When I use union I can't use order by clause. Is
there a way to tell "simply append bot resul
hello everyone,
i have a query like so:
select item.type as ig_id,item.with_design,item_group.type as
group_name, 'true' as valid from item,item_group where item.description
~* 'w/out' and item.type = item_group.ig_id;
and i get duplicates.. how could i remove all the duplicate entrys using
SQL?
