Hi

I have a table with a 3 fields in.
These are LType, Sale og DB.
LType is either 0 or 1.

I would like to make a select that returns this at each line:

Sale (where LType=0), DB (Where LType=0), Sale (Where LType=1) and DB
(Where
LTYpe=1)

Can I do this ?

MAybe with a view ?

My customer would like to have these numbers on the same line to make
some
compares.

Regards Michael