Static Column

[DenisCGN]

Hello,

I Need to create a CSV fiel and therefor I Need to create fixed columns that are not in my table.

How can I add those columns?

I Need a Column called CATEGORY that allways have to be 3 and EXERPT has to be empty.

Where do I put theses columns and how



Thanks,
Denis

[alexa]

On the 'Selection' tab, under the 'Column' column, type the following:

(SELECT 3)

and in the 'Alias' column, type 'CATEGORY'.

Then, add another query field and type:

(SELECT '') and 'EXERPT' respectively.