AS?

How do I use AS?

I want to do a JOIN but I have two columns with the same name. I thought that postgresql might solve this as ACCESS does, by giving the columns names like Table1.id and Table2.id, but he didn't.