I have a table named
Main that contains two fields
I want to select the
name column by two different names. For example:
I have inserted the following records:
id | name ----+------- 1 | Ahmad 2 | Sami
I want to select the data like this:
select Main.name as n1,Main.name as n2 from Main where n1='Ahmad' and n2='Sami'
When I execute this query, it gives the following error:
ERROR: column "n1" does not exist
LINE 1: select Main.name n1,Main.name n2 from Main where n1='Ahmad' ...`
I use PostgreSQL as my DBMS.