Retrieving results from a select in a procedure

[Eric Walker]

I'm new to Sql and sp's , I'd like to know if such a code is possible :

CREATE PROCEDURE waldataservers.StockQuots (Walident integer)
BEGIN
declare str as String:
select field1 from table1 where (field1=walident);
set str = table1.field1;
select field2 from concat(str,'_tableName') where (field2=v);
...
END;

the syntax "set str = table1.field1" seems incorrect.

I need to "create" the table name automatically for the second query.

I don't know if "select" is the best way to achieve this. Cursors may be a clue, but my tables are "big" (15000 records for "table1"), so a loop with "fetch" would take to much time.

Any ideas ?

Many thanks in advance.