generate data from another table constranied by a FK
edward
Posts: 2
I need to generate data from another table but must be constrained by a reference. For Example, with Table A(Aid, c1, BId) and Table B(BId, c2), I want generate TA.c1 from TB.c2 referenced by TA.Bid=TB.Bid. Can anybody give me a hint?