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