Re: joining 2 tables

2013-08-22 Thread Sandeep Nemuri
Thanks for your advice Stephen Sprague. On Wed, Aug 21, 2013 at 9:46 PM, Stephen Sprague wrote: > I'm not sure if you'd call that a join. that just looks like two tables > side by side in some random order. > > the only way to get that (that i can see) is if there is some kind of > function b

Re: joining 2 tables

2013-08-21 Thread Stephen Sprague
I'm not sure if you'd call that a join. that just looks like two tables side by side in some random order. the only way to get that (that i can see) is if there is some kind of function between the two "ids" in the two tables. That way you could join on A.id1 = function(B.id2) otherwise the onl