topic WHERE Clauses in SQL Queries in App Development

WHERE Clauses in SQL Queries

larouge69 — Wed, 25 May 2022 11:47:48 GMT

Hi All,

I'm wondering if there is a way to make a load script using a SQL query with dynamic update of the where clause ?

Example :

Id_Customers:

LOAD

Id_Customers

FROM

FileA;

SQL SELECT

Customer_Id, Customer_name

FROM customers

Where customers.Customers_Id = (or in) Id_Customers (this data come from the file load above);

Thanks

Re: WHERE Clauses in SQL Queries

maxgro — Wed, 25 May 2022 12:18:53 GMT

Try with a variable

Id_Customers:
LOAD * INLINE [
Id_Customers
1
2
3
];

TMP2:
LOAD CONCAT(Id_Customers, ', ') as Field2 RESIDENT Id_Customers;

LET vField2= PEEK('Field2', 0, 'TMP2'); // vField2 = 1, 2, 3

SQL SELECT Customer_Id, Customer_name
FROM customers
Where customers.Customers_Id IN ($(vField2))
;

Re: WHERE Clauses in SQL Queries

vinieme12 — Wed, 25 May 2022 13:43:37 GMT

Alternatively you can use EXISTS()

Example :

Id_Customers:

LOAD

Id_Customers

FROM

FileA;

TableB:

Load *

Where Exists(Id_Customers,Customers_Id);

SQL SELECT

Customer_Id, Customer_name

FROM customers;