You are correct in your statements. your SQL statement would look like
this...
$query = mysql_query("SELECT *
FROM Table1, Table2
WHERE Table1.Value = Table2.Value
");
your Values could be the primary key of each table any other values that
you would like to use to match rows.
gl -- Seth
Noah Spitzer-Williams wrote:
> hey guys,
>
> im trying to figure out a query that i can return rows from more than
> one table at a time. for example, i have two identical tables in structure
> and i want to return rows from both using one query. maybe this will help:
>
> select * from table1 and table2 where condition='value'
>
> is there any way to do this?
>
> thanks!
>
> - Noah
>
> ----------------------------------
> TradeMyTraffic! Web Services
> http://www.trademytraffic.com
>
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
