6 Replies Latest reply: Jul 31, 2012 6:14 AM by sade_qlk RSS

    -- SQL : How to select all fields + add a field in the same query? --

      Hello,

      I have a question about using SQL in QlikView:

      I have these 2 queries and I want to merge them:

       

      1/  select *

           from----

       

      2/  select 'TOTO'   as Name

           from----

       

      and I want to do something like :

      select *,'TOTO'  as Name

      from---

       

      but of course this doesn't work.

       

      Someone have a idea?