What are the challenges you face when working across database platforms? Take the survey
Options

generate data from another table constranied by a FK

edwardedward Posts: 2
edited May 12, 2014 9:15AM in SQL Data Generator
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?
Sign In or Register to comment.