11-11-2016 05:37 PM
I have 2 datasets;
What is the fastest way to get this result? Anyone can help? Thanks.
Name Age Location
John 70 London
Apple 67 London
June 67 London
Ewan 43 London
11-11-2016 06:47 PM
Fastest to program? Fastest to execute? Fastest to explain how it works?
Here's one way:
if _n_=1 then set b;
The full Cartesian product (already suggested) is a short program as well:
create table want as select * from a, b;
You can test them on larger data sets and let us know which one is faster.