Mike,
I know quite a bit about joins and I'm not sure if they are the answer.
Basically I want to save myself two SQL statements.
I'd like to combine:
select * from table1 where cond=val
select * from table2 where cond=sameval
into one sql statement. the two tables are identical in structure thats
why i think there should be some way to do this.
Thanks!
- Noah
----------------------------------
TradeMyTraffic! Web Services
http://www.trademytraffic.com
<[EMAIL PROTECTED]> wrote in message
006601c21bd8$4b1fdb20$[EMAIL PROTECTED]">news:006601c21bd8$4b1fdb20$[EMAIL PROTECTED]...
> SQL JOINs...
>
> http://www.mysql.com/doc/J/O/JOIN.html
>
> -Mike
>
> ----- Original Message -----
> From: "Noah Spitzer-Williams" <[EMAIL PROTECTED]>
> To: <[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
