I've a select statement of the following syntax:
where id = 1 or 2 or 3;
Because the list of applicable IDs is considerably long I'd like to simplify the statement to something like
where id in IDlist;
Any ideas on how to achieve this?!
Where Exists (IDlist, ID)
Where IDlist is a table like below
Load * Inline
one more question.. although the script runs..
the Where Exists(IDlist, ID) statement doesn't yield the return that
where id = 1 or 2 or 3 does...
In fact it seems the exists function doesn't find any matches?
might be you can use
where Id >=1 and <=50
if its in sequence!
this is exactly what I was looking for!
Now instead of using inline tables I'll look if I can just import the relevant ID's from my source files.
Thanks a bunch!
Try this sample..
Where Exists (IDList, ID);
Drop Field IDList;
Retrieving data ...