mysql no subquery

[Guest_imported]

Please help, I need to create two tables, the first of which(table A) is a join of two tables and the second (table B), a join of three. I then need to scan every record of B for matches in A. I'm usung mysql, therefore I can't use subqueries to create the tables and so I need to do it in three stages. Create table B, create table A, then scan them. My question is : is it better (resource wise) to create two temp tables then scan, or would it be more efficient to pass the output record set of A and B back to php and scan there? Thanks for your help in advance, Rick. PS, if A had 1000 records and B had 1000 records, if I dump two temp tables onto my server while I use mysql to scan them, how long would it take and would it compleatly lock up my virtual server for that amount of time(and therefore all sites hosted on my server).

 

[KarveR]

Dunno if this sort of thing helps?

SELECT a.stuff,b.things FROM table1 a,table2 b WHERE b.thing_to_match = a.thing_being_matched;
______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.