Skip to Content
0
Former Member
Apr 22, 2008 at 03:07 PM

Insert a column with fixed value in a query

394 Views

Let's say i have a query:

Columns:

KF1

KF2

KF3

Rows:

Char1

Char2

Char3

Attribute1

Attribute2

Attribute3

Char4

So, after launching this query, it displays like this:

Char1 | Char2 | Char3 | Char4 | KF1 | KF2 | KF3 |

dsd sdsd sdd sdsd 34 34 56

sdsd fgfg ghgh yuyu 25 76 87

So, i need to insert a column between Char3 and Char4 That would have a title i want (let's say: "TEXT") and all the values of that column would be a set of characters, let's say: "R2"