var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: cartesian product without repeating pairs inversed
i have a table with one column, i want to extract all pairs (a,b) where a in table and b in table and if (a,b) is on the result (b,a) must not be extracted ..
can i do that white an sql request ?
of course, this only works if the col values are unique, which they would have to be because the table has only one column, so this column has to be the primary key, and therefore unique
SELECT t1.col AS a, t2.col AS b
FROM daTable AS t1
JOIN daTable AS t2
WHERE t1.col < t2.col
otherwise it's not a table, it's a bag
Yes, This is it !! Thanks