maybe yes if you concatenate all ID from T1 and the variable is 'v1,v2,v3,......'
so you can use the variable in SQL select
this is a different solution
Load Distinct ID from t1.qvd;
// get all rows from sql, no filter (SQL Select....)
// filter the rows returned by sql (Load * ....)
Load * where exists(ID);
SQL Select ID, Name from mytable;
Store T2 into t2.qvd (qvd);
Drop Table T1;
This is the exact code I've implemented;
Load Concat(Chr(39) & AST_VRF_PROD_OID & Chr(39),',') As AST_VRF_PROD_OID;
Load Distinct AST_VRF_PROD_OID from ICMLog.qvd (QVD);
Let strOIDs = FieldValue('AST_VRF_PROD_OID',1);
The resultant variable strOID contains repetitive values. Here is a sample as the string is very long and fails within the SQL statement.