Date: 06/24/02
- Next message: szii <email protected>: "Re: [PHP-DB] Works with one server and not the other"
- Previous message: Noah Spitzer-Williams: "[PHP-DB] check two tables at same time?"
- In reply to: Noah Spitzer-Williams: "[PHP-DB] check two tables at same time?"
- Next in thread: Noah Spitzer-Williams: "Re: [PHP-DB] check two tables at same time?"
- Reply: Noah Spitzer-Williams: "Re: [PHP-DB] check two tables at same time?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
SQL JOINs...
http://www.mysql.com/doc/J/O/JOIN.html
-Mike
----- Original Message -----
From: "Noah Spitzer-Williams" <noahsw <email protected>>
To: <php-db <email protected>>
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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: szii <email protected>: "Re: [PHP-DB] Works with one server and not the other"
- Previous message: Noah Spitzer-Williams: "[PHP-DB] check two tables at same time?"
- In reply to: Noah Spitzer-Williams: "[PHP-DB] check two tables at same time?"
- Next in thread: Noah Spitzer-Williams: "Re: [PHP-DB] check two tables at same time?"
- Reply: Noah Spitzer-Williams: "Re: [PHP-DB] check two tables at same time?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

