In response to John Zhang :
> 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
> an
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.I
