topic Nested SQL in FlexSim Forum

Nested SQL

chanykE2WUT — Thu, 03 Apr 2025 08:52:49 GMT

[ 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"]);
}

Re: Nested SQL

FelixMoehlmann — Thu, 03 Apr 2025 11:13:04 GMT

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]")

Re: Nested SQL

chanykE2WUT — Fri, 04 Apr 2025 01:46:50 GMT

@Felix Möhlmann Thanks

David