Query

I got a table
code name active
1 thomson 1
2 sony 1
3 vettori 1
4 nash 0
I need to take all the active ones
So I write select name from table where active =1
Mean while I made the status of Thomson to inactive ie :0
I need a query to get all the active ones + Thomson, whether it is
active or inactive
Thanks in advance
thomsonTry this
Select * from table where active=1
Union
Select * from table where name='Thomson'
Madhivanan|||Hi,
is there any method to avoid union
regards
thomson
Madhivanan wrote:
> Try this
> Select * from table where active=1
> Union
> Select * from table where name='Thomson'
> Madhivanan|||What about this one?
Select * from table where active=1 or name = 'Thomson'
Madhivanan