Posted by Brian on 11/27/06 14:02

Hi there

I am trying to write the follwoing statement in the best way possible
in a PHP page. I think i need to use a join somewhere but i always
get confused with them, also trying to work out if it can be done
without using a loop from the first search

I have 3 tables,
T1
T2
T3

T1 and T2 have the same structure but just called different names

User inputs a "search"

SELECT `ACol` FROM `T1` WHERE `T1ACol` = "search" < this may bring back
more than 1 result

Now

SELECT `FieldA`, `FieldB`, `FieldC` (< Fields A,B,C from both T2 and T3)
FROM `T2`,`T3`
WHERE T2ACol = the above results
OR
T3ACol = the above results

Thanks

Brian

[Back to original message]