Hi all,
I was wondering how I can add a column and populate it by some query.
For example:
TblA (Id, fld1)
TblB(Id, fld1, fld2)
I have a query:
SELECT b.fld2
FROM tblB b
WHERE condition1
what I want to do is add a column in tblA: fld2
and polpulate the newly added field with the query
on tblA.Id=tblB.Id
Any advice? Any input would be much appreciated.
Thanks a lot
John