In this sample table, I am trying to select the row that has a value of 2 in :Number, then grab the value "A" from :letter then select all the rows contains "A" in :Letter.


I wrote this script but it is not working.
dt= current datatable();
dt <<SELECT where=""></SELECT>
looking at the log
s = {"A", "A", "A", "B", "B", "B"};
And no rows were selected at the end of the script.
What went wrong?
Thanks