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