Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's,
How do i write direct query syntax on below sql query
SQL SELECT *
FROM dbo.Agents;
I written like below it's throwing error.
Direct SELECT *
FROM dbo.Agents;
Thanks,
Sateesh.T
Hi,
Refer Qlikview Help File (F1), there is lot of info and examples on this. The syntax is bit different
Regards,
Jagan.
You have to update your current statement
Direct SELECT *
FROM dbo.Agents;
to
Direct SELECT
Dimension
Dim1,
Dim2,
Measure
Mes1
.....
FROM dbo.Agents;
Where Dimension & Measure are keywords for your Direct Query