Joint or Alias

[#1]

Hello everyone,

Actually, I try to know exactly what it's mean and how to use in qlikview:

(oracle SQL)

Select

    D.field1,  <-----

    field2,

    field3

from

    Data D  <--- they put an alias to use with the first field

AS I Said above, I need an equivalent in qlikview.

Regards

[Anonymous]

Hi ,

I think you have a query which is extracting data from SQL

you can use join here as well and in preceding script just alias the column names as required.

if you want you can use

Select

    field1,  <-----

    field2,

    field3

from

    Data

if you dont need to join with any table

(we use Alias name in Sql for columns which have same name in both the tables (joined with))

Thanks

BKC

[buzzy996 · Accepted solution]

see this,

Select

    field1 as uraliasname,

    field2,

    field3

from

    Data D