Getting data from other table?

shnekshnek Posts: 4
edited January 19, 2015 6:10AM in SQL Data Generator
I know you can easly access data from another column in the same table, but is there a way, for example using python script where I can access data from a specyfic column in another table?

Comments

  • Alex BAlex B Posts: 1,131 Diamond 4
    Hi Schnek,

    You can use the Generic > SQL Statement generator to get data from a column in a different table that is being generated. So if you have column one in table1 and column two in table2 (both int for instance), if you use the SQL Statement generator for column two in table2 and have the following query:

    SELECT one
    FROM table1

    Then both column one in table1 and column two in table2 will have the same data (ensure you uncheck Shuffle data). You could probably do something similar with IronPython in the script generator as well.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.