Re: Illustra advice

wjb@sky.net (wjb) writes: >two questions about web datablade - >1) is it possible to load one table with multiple SQL queries > on each row? I'd guess you'd have to combine the two queries into one, i.e., select a.first_column, b.second_column from a, b where join_a_and_b_here;That you're trying to put results from both a and b in a single table row suggests that there's some relationship between a and b to express in a join. If not, how about creating a temporary table with fields for the columns from a and the columns from b, filled in with two separate queries, and then the <?/MISQL> loop reading from that temp table? Seth -- Seth Grimes -- grimes@access.digex.net -- http://www.access.digex.net/~grimes grimes@magnet.com -- http://www.magnet.com