CODEWITHSUNDEEP
sql-server
Pramod
Pramod

Reputation: 33

SQL Server query problem

I am using SQL Server 2000. My table looks like this:

stricker    nonstricker    over      status
-----------------------------------------------
sahwag      sachin      0.1        out(sahwag)
kohli        sachin      0.2        not out

I want the name of the batsman, like this:

------------------
sahwag
sachin
kohli

Upvotes: 1

Views: 64

Answers (1)

alex
alex

Reputation: 3720

I think this is what you want. This will get both the strickers and the nonstrickers from the table:

select stricker from myTable
union
select nonstricker from myTable

Upvotes: 3

Related Questions