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 hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?