Hi John, Firstly, apologies for troubling you this frequently.. I was curious how could I achieve LEFT OUTER JOIN using FastBit; for instance if I have following two tables 'a' and 'b' and I do Join a and b on first column (a.first_col=b.first_col) and then select b.second_col, sum(a.second_col), I get USA-500, UK-100, NULL-500 as result?
Is it directly possible using existing fastbit? If not what would be the best way to implement this? cheers, gaurav --------- a --------- 1,200 1,300 2,100 3,400 4,100 --------- --------- b --------- 1,USA 2,UK ---------
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
