Select statment in one alias column

[mysqlquestion]

How can I can combine 2 queries in one and get the result under one column
Query 1 and Query 2
Select Employee 'A' as FC from Employee
Select Employee 'C as FC from Employee
thank you very much
I want Output to be like this
Employee FC
1 A
2 A
3 A
1 C
2 C
3 C

[bitsmed]

Use "union all"

[ScottPletcher]

Select Employee, FC
from Employee
cross join (
    select 'A' as FC
    union all
    select 'C'
) as cj1

[JeffModen]

Ok... I'm curious. What is the purpose of this query? As written, it makes no practical sense.

[harishgg1]

hi

also possible with

UNPIVOT

just something different .. as a solution