Re: Index Problem on 3.23.20, with Large Query

[Dan Nelson]

In the last episode (Jul 06), Joe Kislo said:
> 
> 	Yep, read that. However I need to populate the table with
> -multiple- constants.  They're not located in any database, so I
> can't select them out of a table.  What I want is some select
> statement that would return say
> |--|
> |33|
> +--+
> |22|
> +--+
> |46|
> ----

I'm a bit confused.  Are you trying to populate a table, or select
data?  If you want to fill a table with a bunch of rows in one command,
"INSERT INTO table VALUES (33),(22),(46)" will work.   If you want to
grnerate an arbitrary SQL resultset from a select statement with no
backing table, I'm not sure that's possible.
 
-- 
	Dan Nelson
	dnelson@stripped