I have are a set of create table statements having Select queries with multiple conditions. Some of the conditions include filters for the current date like:

'Create table emp_hrs as

(select count(emp_hours) from Emp_table where emp_name='BOB' and func_date='2012-09-19')

And there are multiple insert statements to create one table by pulling out the data from multiple tables as created above.

I have to use a 'select * from' statement to pull out the data from the final table.

I hope you get a picture of this.

Thanks,

Prasanna