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 price3

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 colname 0