Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to use multiple field values to determine in a not exists statement,eg:
a | b | c |
1 | 2 | 3 |
4 4 | 4 5 | 6 6 |
4 6 7 | 5 5 8 | 4 6 9 |
I want the result
exists a=4 and b=5 and c=6
please help me,thank you!
Where do you want this? Script or front end? and you want where exist or where not exist?
Hi Sunny,I appreciate your apply quckly!
The statement i wanted in script and the result i want was exists a=4 and b=5 and c=6!
Thank you very much!
Not sure I understand completely, but have you tried this
LOAD a,
b,
c
FROM ....
Where a = 4 and b = 5 and c = 6;