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'