<div>
hmmm...are you wantin a list of all possible values from the tables in your new table? &nbsp;if so, you can do this (without a loop)<br />
<br />
select zip, title, description<br />
from zip, products, accessory<br />
where orderid= x and productid = x and accessoryid= x
</div>


hmmm...are you wantin a list of all possible values from the tables in your new table?  if so, you can do this (without a loop)

select zip, title, description
from zip, products, accessory
where orderid= x and productid = x and accessoryid= x

<div>
can you give us more details?<br />
table structures with sample data and what you want to do with the data?
</div>


can you give us more details?
table structures with sample data and what you want to do with the data?

<div>
&gt;&gt;select zip, title, description<br />
from zip, products, accessory<br />
where orderid= x and productid = x and accessoryid= x<br />
<br />
<br />
but x would be orderid<br />
and orderid goes from 1 to 1000
</div>


>>select zip, title, description
from zip, products, accessory
where orderid= x and productid = x and accessoryid= x


but x would be orderid
and orderid goes from 1 to 1000

<div>
THEN DESCRIBE YOUR PROBLEM BETTER.
</div>


<div>
can you provide us with the table structures along with the foreign key columns or relations between the tables marked?
</div>


can you provide us with the table structures along with the foreign key columns or relations between the tables marked?

<div>
&gt;&gt;can you provide us with the table structures along with the foreign key columns or relations between the tables marked?<br />
<br />
not sure
</div>


>>can you provide us with the table structures along with the foreign key columns or relations between the tables marked?

not sure

<div>
Can you provide sample set and expected result?
</div>


Can you provide sample set and expected result?

<div>
<div class="content wysiwyg-content">
INSERT INTO newTable <br />
SELECT <br />
(SELECT zip from orders where orderid = x ) as Zip, <br />
(SELECT title from products where productid = x ) as Title, <br />
(select description from accessory where accessoryid &nbsp;= x ) as description<br />
<br />
could this be put into a for loop and all the values of the table populated
</div>
</div>


INSERT INTO newTable 
SELECT 
(SELECT zip from orders where orderid = x ) as Zip, 
(SELECT title from products where productid = x ) as Title, 
(select description from accessory where accessoryid  = x ) as description

could this be put into a for loop and all the values of the table populated

sql server for loop

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.