Options

performing a lookup on another table

doreynoldsdoreynolds Posts: 3 New member
in SQL Data Generator

creating a synthetic data gen project.

Within the table i'm populating i have two fields relevant to this question: a ProductId field which acts as an Id to a row in another table and a TotalValue field. I want to use the Id field to lookup the price in another table and then multiply this price by a random order quantity.

Tagged:
· Share on Twitter

Answers

  • Options
    Dan_JDan_J Posts: 449 Silver 2
    Hi @doreynolds

    Thanks for reaching out to us regarding this.

    I understand my colleague Eddie has reached out to you via the ticket (268290) we have open for you for this issue. We will continue to troubleshoot this with you via that ticket.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • Options
    doreynoldsdoreynolds Posts: 3 New member
    i received an answer, but just want to check. you are saying that when i'm specifying the sythetic generation i can't use one of the fields as part of a sql query ?  i wasn't wanting you guys, to write a generator for me just trying to understand the product and what it can do. if i've raised this question in the wrong place just tell me where i should raise instead). thanks
    · Share on Twitter
Sign In or Register to comment.