Question: Trying to Avoid nesting a query

[patsfans]

I have a huge join that brings together six tables and works perfectly for grabbing single results, but I'm trying to expand it and solve an issue to avoid nesting it inside of a second query.

For the sake of making it simple let's basically say that what I'm trying to do is this:

$sql = mysql_query("SELECT value1 FROM Table");

while ($row = mysql_fetch_array($sql)) { 	

$value1 = ($row["value1"]);

$sql2 = mysql_query("SELECT new1, new2, new3 FROM Table2 WHERE id = \"$value1\"");

// rest of query stuff here
}

I did something similar a while back but I can't find my notes to see how I solved this and was hoping this was something someone here might now a solution for.

[Derokorian]

Not sure if this is what you mean or not, but sounds like a basic join to me. Maybe you've simplified it too much for me to see the forest through the trees.

select t2.new1, t2.new2, t2.new3 from table2 t2 join table1 t1 on t1.value1 = t2.id