Nested SQL

[chanykE2WUT]

[ FlexSim 25.0.4 ]

Hi I am trying add the value from Table 1 column slprice to another table Table 2 column slprice1 using one line of SQL. I have tried using nested SQL, but all fails. The only code that works is with a for loop which I tried to avoid. Any suggestion?

Table 1

Table 2

Table result = Table.query("UPDATE Test3 SET slprice1 = (SELECT slprice FROM Test2 WHERE Test3.ROW_NUMBER=Test2.ROW_NUMBER)"); //Nested SQL

Table result = Table.query("SELECT slprice FROM Test2");
for (int j=1; j<=result.numRows; j++)
{
Table result1 = Table.query("UPDATE Test3 SET slprice1= $1",result["slprice"]);
}

[moehlmann_fe · Accepted solution]

The MySQL syntax from the link below works. (Square brackets not strictly necessary)

https://stackoverflow.com/questions/224732/sql-update-from-one-table-to-another-based-on-a-id-match

Table.query("UPDATE [Test3], [Test2] SET [Test3].[slprice1] = [Test2].[slprice] WHERE [Test3].[ROW_NUMBER] = [Test2].[ROW_NUMBER]")

[chanykE2WUT]

@Felix Möhlmann Thanks

David