Questions tagged [table-alias]
65 questions
-1
votes
1 answer
Foo meaning in postgresql
I heard that foo is used as a table alias but why is it needed?
ex. When I try to run the code on pgadmin4 it doesn work without the foo and says that the subquery inside From must have an alias. ( Think my knowledge with the whole alias is lacking…
dxter327
- 1
- 1
-1
votes
1 answer
What .* does in PostgreSQL ? and is there no necesarry to write AS to rename a variable?
I saw this query, and I'm still not really a pro in PostgreSQL. I want to know what does the .* after the vi and also i see that they rename tables without the as, it works but I wanted to know if its a common practice.
select vi.* ,…
-1
votes
1 answer
ORA-00904 when for inner joining same table
My query is :
select right.* from Table1 JOIN Table1 right on (right.field1 = left.field1)
I need to expand this query even more with where clause.
But this itself is throwing, ORA-00904 : invalid identifier error.
Sivakumar S
- 5
- 2
-1
votes
1 answer
how to use upper query table alias in inner query in subquery
select upp.item_total,
(select sum(iva.total_item_value_afs)
from (select sum(item_value_afs) total_item_value_afs
from (select distinct inn.reg_no,inn.tpt_cuo_nam, inn.item_total, inn.item_value_afs
from…
Mohammad Jalal Ahmadzai
- 31
- 1
- 7
-3
votes
1 answer
subquery must have an alias
I have this query I have written in oracle that returns an error saying:
subquery must have an alias any help please i need to convert it to PostgreSQL so the query will executed in order to create a pipeline in elasticserver.
aymen krifa
- 1
- 1