2. PHPRunner General questions
  3. Multiple WHERE in lookup wizard
This topic is locked

Multiple WHERE in lookup wizard

 		6/14/2023 6:57:58 PM
PHPRunner General questions
G
 gonzalosb author

how can i do my dropdown base in 2 or more WHERE?
I have my CUSTOMER table that have NAME, TYPE and LEVEL.
need my WHERE to be base on TYPE and LEVEL and i cant make it work
Type='1';
Level='3';
i can mke it work with one but not with bouth at the same time. im missing something herer?
please help! THANKS
Sergey Kornilov admin 6/15/2023

You need to learn basics of SQL language:
WHERE Type='1' OR Level='3'
WHERE Type='1' AND Level='3'