Re: check two tables at same time?
| From: | szii at sziisoft dot com | Date: | Mon, 24 Jun 2002 23:38:48 +0000 |
| Subject: | Re: check two tables at same time? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20070@lists.php.net to get a copy of this message | ||
SQL JOINs...
http://www.mysql.com/doc/J/O/JOIN.html
-Mike
----- Original Message -----
From: "Noah Spitzer-Williams" <noahsw@cyberdude.com>
To: <php-db@lists.php.net>
Sent: Monday, June 24, 2002 4:21 PM
Subject: [PHP-DB] check two tables at same time?
> 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