Hi ALL,

I have a table  that save employee number for flow of approving requests and sequence number for each one

I want to retrive name of every one who have sequence number 1 and every one who have sequece number 2

that mean I want to retrive employee number more than one time the same query but with differne condition then

connect it with other table to get the name

Please help me ASAP

khalid

Use a sub query or

u can insert the values into a temporary table and can obtain the output using a select query or

The best option is

write a select -- case statement

like

select case colName when null then ' ' else colname end  from table where _id = _id  )) as retValue

Hope this helps you

Hi,

You can use the union all operator:

select *, '1' as seq from table where sequence=1

union all

select *, '2' as seq from table where sequence=2

The "'1' as seq" in the query is for you to be able to tell the difference in your logic.

Hope this helps. Please be more specific on the tables structures if it doesn't.