SQL Joins
Posted: Thu Feb 28, 2008 4:25 am
Hi,
how do i join 2 tables based on a third "index" table
for example, i have one table with buyer name and buyer id, one table with seller name and seller id, and a third table with user id and buyer id
how do i get a list of buyer name and seller name, using table 3?
thanks
how do i join 2 tables based on a third "index" table
for example, i have one table with buyer name and buyer id, one table with seller name and seller id, and a third table with user id and buyer id
how do i get a list of buyer name and seller name, using table 3?
thanks