[thelist] [mysql] join

kris burford kris at midtempo.net
Fri Jan 23 11:13:18 CST 2004


hi all,

need a select from two tables where table_one contains two id numbers 
relating to different rows in table_two

can do this in multiple queries:
$sql_one = "select id_one, id_two, some_other_stuff from table_one where x";
query
fetch_rows
$sql_two = "select name from table_two where id = id_one";
$sql_three = "select name from table_two where id = id_two";

is there any way that this can be done in a single request? could really do 
without the extra overhead on the db...

tia

kris

<tip author="kris burford" type="usability">
the wichita state university have a usability newsletter where they report 
some of the web oriented findings by their department of psychology. it's 
often a good source of ammunition when you need that little bit of 
impartial support. http://psychology.wichita.edu/surl/newsletter.htm
</tip>



More information about the thelist mailing list