Hi Lalit,
It would surprise you (as it did me), you can’t use the * (wildcard).
The solution is to name the Attributes you like to select. Here is an example:
'
SELECT
E.Timestamp Timestamp,
E.Application Application,
E.System System,
E.Model Model,
E.Location Location,
E.EnergyContract EnergyContract,
E.Country Country,
E.EmissionCO2 EmissionCO2,
E.EmissionCH4 EmissionCH4,
E.EmissionN2O EmissionN2O,
E.kWh kWh,
E.Platform Platform
FROM
Emission.EmissionReport E
WHERE
E.Timestamp >= $TimestampStart AND
E.Timestamp <= $TimestampStop AND
E.Application IN $Application AND
E.System IN $System AND
E.Model IN $Model AND
E.Location IN $Location AND
E.EnergyContract IN $EnergyContract AND
E.Country IN $Country
E.Platform IN $Platform
'
Go Make It
'SELECT
P.id Project_Project,
P.ProjectName
FROM
M.Project P'
we have to create a self association to access id