I have wrote query to fetch the data.

```
select Terr, Product 
from sdata, md 
where sdata.PSetID = md.PsetID;

```

I want to copy this fetched data to new table.

I tried following query but it didn't work:

```
select * 
into ttl 
from 
    (select Terr, Product 
     from sdata, md 
     where sdata.PSetID = md.PsetID);

```

What am I doing wrong?