sql query help

bimmer528

Can anyone lend me a hand here?

I am trying to pull data from a second sql query using a where clause = two fields from the first query. I am trying to gather from the second query, any data where we have a match from either of the two in the where clause.

sql=my select 1,2 from t1

while $row {

$one=$row[1];
$two=$row[2];

sql=select 1,2 from t2 WHERE 1 = '$one' or 2 = '$two' group by 1,2

while $row2 {

//trying to output all rows that either 1 or 2 from t2 match 1 or 2 from t1.

so all grouped results from 1 display all unique results in 2
all grouped results from 2 dispaly all unique results in 1 where either 1 from t1 = 1 from t2 or 2 from t1= 2 from t2.

}
}

laserlight

You may be able to use just one query.
Outline the relevant portions of your database schema, and state what do you want to select.

bimmer528

sql=select f1,f2 from t1 group by f1,f2

lets say a row is

5,10

sql=select f1,f2 from t2 where f1='5' OR f2='10' group by f1,f2

I need all results in f2 in t2 where f1=5 and at the same time I need all results in f1 where f2=10

laserlight

Okay, so you have two tables.

Table: table1
field1
field2

Table: table2
field1
field2

I need all results in f2 in t2 where f1=5 and at the same time I need all results in f1 where f2=10

Sounds like you want two queries:

SELECT table2.field2 FROM table2, table1 WHERE table2.field1=table1.field1;

SELECT table2.field1 FROM table2, table1 WHERE table2.field2=table1.field2;

bimmer528

thats have I have been doing is seperate queries but is the second query doing a query on each row from the first query without joining the table? Meaning, is it ok and will it work to do a second query while in the first query loop and will the second query output each result in it's loop? I have been having some trouble so I posted to see if I can eliminate the need for two queries each getting results from the main query and cut it down to just 1 query off the first query.

laserlight

Meaning, is it ok and will it work to do a second query while in the first query loop and will the second query output each result in it's loop?

You dont need a loop, only two queries. If you use a loop, it will be one query for the loop, and one query for each iteration of the loop.