view blunder postgresql


i have infinite query postgresql database.
the query something this:



select * table1, table2, ... where table1.id = table2.id...


when i run query sql query, advantage wanted row.



but i tries same query emanate view, advantage an error:



"error: buttress "id" specified some-more once."



(i pgadminiii executing queries.)



i'll speculation happens since resultset have some-more buttress named "id". there somehow solve this, but minute buttress names query?



Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members