I was wondering how I can add a column and populate it by some query.
TblA (Id, fld1)
TblB(Id, fld1, fld2)
I have a query:
FROM tblB b
what I want to do is add a column in tblA: fld2
and polpulate the newly added field with the query
Any advice? Any input would be much appreciated.
Thanks a lot
pgsql-sql by date
|Next:||From: A. Kretschmer||Date: 2009-02-25 06:33:59|
|Subject: Re: Add column by using SELECT statement|
|Previous:||From: Fernando Hevia||Date: 2009-02-24 19:59:01|
|Subject: Re: Best practices for geo-spatial city name searches?|