Arrays

[Lop]

I'm pulling data from a SQL DB and have to combine two tables. So I have a query that runs and inside the while calls another query and retrieves data based on the first query data.

I've created an array and am storing data in it but as I'm doing it I am thinking about how this can't be the best way. I need to store 6 values, 5 from one db and 1 from the other. In the while loop I assign the data like

PHP Code:

$myArray[i][0] = $row[...];
$myArray[i][1] = $row2[...]; // Value from second db
...... 


What is the best way to do this? I know there is a better way.

[John]

i believe you can query two tables using a UNION, however im not sure the exact syntax but i believe its something like

PHP Code:

(SELECT a FROM table1)
UNION
(SELECT b FROM table2) 


i think

[Jordan]

Use a join

PHP Code:

<?php
// Make a MySQL Connection
// Construct our join query
$query = "SELECT family.Position, food.Meal ".
 "FROM family, food ".
    "WHERE family.Position = food.Position";

Code taken from and for more information: http://www.tizag.com/mysqlTutorial/mysqljoins.php

This is MySQL code but the query should work the same with msSQL.