[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