I somehow doubt this will work but try this::
Select * from t1, t2 where...
Yeah, that wont work. i havent tried it but I think it aint gonna help. I
send this anyway just as a what if.
- Deryck H
- http://www.comp-u-exchange.com
----- Original Message -----
From: "Islam, Sharif" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 04, 2001 4:42 PM
Subject: Query Help
> I have this two table.
>
> table1:
>
> ID Name Phone someother fileds....
> 1 Bob 1234
> 2 Joe 5678
> 3 Mary 5678
> 4 John 6789
>
> table2:
>
> ID Name Email
> 1 Bob [EMAIL PROTECTED]
> 2 Joe [EMAIL PROTECTED]
> 3 John john@
> ----------------
>
> the query :
> select t1.Name, t1.Phone , t2.Email from t1,t2 where t1.name=t2.name works
> fine.
>
> But I want to display all the names. Table2 doesn't have all the names, so
> for example mary is missing , because she doesn't have email address. I
want
> to display all the info about everyone, regardless if they have email
> address or not. Is that make sense? Any hint.
>
> thanks
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
