Latest Activity

code

Column not found

Hello, I am extracting data from other view and using statement like below select field1 as column1 , field2, field3 from viewEx; but I am getting error column1 not found can you please help

alias

code

Alis names in VQL

Hi Team, How can we give alias name with spaces to view columns For example I would like to call Source_date as [Source Created Date - Study]

alias

code

create or rename an aliass name

I want to create an alias name for the view i had select. Can you tell me if that is possible. And if so, how we can do that. An example for what i want: 1) new --> join 2) drag and drop a view called v_test 3) Then again drag and drop the same view ...

alias

code

can subquery be used in join condition?

I'm trying to get the row from table1 with the max effective_date less than or equal to table2.effective_date select blah from table1, table2 where table1.effective_date <= (select max(effective_date) from table1b where table1b.key = table1.key and ta...

subquery alias