Hello to all
I have the following sql:
select phones.*, ops.plid, ops.box, ops.mac,
concat(phones.prefix1,phones.suffix1) as complete_phone
from phones inner join ops
on phones.suffix1 = ops.phone
I do want to get the items from table ops for display of relationship of
data to table phones but I also want
to get ( in this instance ) all phones that do not have "phones.suffix1 =
ops.phone". In other words
I want to get everything in table phones, obtaining the data from ops if
there is a suffix present in ops but
in addition I want the phone information if I find no values in ops. (Fun
huh!!! :->)
---------------------------------------------------------------------
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
