


Hello,
I have a table with a set list of card values and I want to assign them to my inbound population. Both tables don't have a field I can join on in the traditional sense. If a card value has a promotion history id assigned to it then it can't be used. I heard a cross join could be used but I am not sure of the java that is required.
Any ideas?
Solved! Go to Solution.
Views
Replies
Sign in to like this content
Total Likes
Hi,
Every recipient gets a copy of all cards (cross)? Every recipient gets one of the available cards (left join on line number)?
Neither join would require java, but for 1:n a pivot does have to be applied (n has to be specified).
Thanks,
-Jon
Views
Replies
Sign in to like this content
Total Likes
Hi,
Every recipient gets a copy of all cards (cross)? Every recipient gets one of the available cards (left join on line number)?
Neither join would require java, but for 1:n a pivot does have to be applied (n has to be specified).
Thanks,
-Jon
Views
Replies
Sign in to like this content
Total Likes