Displaying multiple keyword fields

[Richard_Otis]

I've recently created a custom SQL query and am running into issues with getting multiple keyword types to show as display columns.  In my select statement I was thinking I could use kt1.keyvaluechar, kt2.keyvaluechar etc....

I can use the first keyvaluechar but when I add the second I get an error saying "There is already a display column with the same id"   

I'm assuming this can be done so I've got to be missing something.   

 Here's my select statement

select i.itemnum, bt.keyvaluechar, dt.itemtypename, i.datestored, ct.keyvaluechar

[Jason_Ricker]

You'll want to Alias the keywords so they display. Basically its trying to display 2 columns as "Keyvaluechar" the prefix is only telling what table it's calling on. Here's an example I'm working on. Aliasing the keywords should solve your problem.

select distinct itemdata.itemnum, itemdata.itemdate,itemtypename,

RTrim(keyitem***.keyvaluechar) as ____ ,

RTrim(keyitem***.keyvaluechar) as ____ ,

~Jason