Re: Crazy mysql statements.. what if..

2002-01-04 Thread Roger Baklund
* Roger Davenport > I'm trying to do the impossible I think but what I'd like to do is join > two tables, using the "colname" results from "a" table to lookup a > column named "colname" in b... here we go. I don't think you can do that, but... > suppose we have > > table a: > id coln

Crazy mysql statements.. what if..

2002-01-04 Thread Roger Davenport
I'm trying to do the impossible I think but what I'd like to do is join two tables, using the "colname" results from "a" table to lookup a column named "colname" in b... here we go. suppose we have table a: id colname 0 price1 1 price2 2 pr