Q&A BY TAG 'alias'

You must sign in to ask a question. If you do not have an account, you can register here

create or rename an aliass name
answered 02-05-2016 10:32:42 -0400

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 ...

Answers: 1


can subquery be used in join condition?
answered 25-08-2015 04:41:05 -0400

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...

Answers: 1

subquery alias