Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have an inline table lets call it X; It contains employee_number.
Load Inline [
Emp_no
123
234
345];
Later on I need to use/extract all of the employee_numbers above, in an 'in' Clause in SQL eg
select emp_no from Employee_table where emp_number in ('123','234','345')
How can I achieve this?
Thanks
Hi,
You can try using Where Exists function like below:
Load * Inline [
emp_number
123
234
345];
Load *
where Exists (emp_number);
SQL Select * from Employee_table ;
Hi,
You can try using Where Exists function like below:
Load * Inline [
emp_number
123
234
345];
Load *
where Exists (emp_number);
SQL Select * from Employee_table ;
I am joining those tables later so I don't want to do an exist in this instance
Why not?
How is the result of this solution different from what you described?