Re: SQL question - doing select from (determined at run time)

No can do, well not directly, you need to two stage it using esql/4gl/perl-DBI etc or if you are on the latest engines then write a UDR or whatever they are called. david_henry@my-deja.com wrote: > > what I would LIKE to do is something like > > create table tables_names( > code int, > name char(50) > );> > insert into table_names values(1,'database@server:table');> > select * from (select name from table_names where code=1);> > which would be the same as > > select * from database@server:table;> > I'm stymied by that fact that the FROM clause must be a table name and I > can't use a sub-query. > Any ideas? I'm using dynamic server V7.31. > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #