Hi. I need to do a search like this
SELECT DISTINCT namep,namef FROM printers,fax WHERE namep LIKE 'Xerox%' AND
nomef LIKE 'Xerox%';
I had in the database data like Xerox N-2125 or Xerox N17.
I think I must use a "subselect" or something like because i get duplicate
results. Any help will be helpfull. Thanks in advance.
Results:
+--------------+-------------+
| namep | namef |
+--------------+-------------+
| Xerox N-2125 | Xerox DC255 |
| Xerox N17 | Xerox DC255 |
| Xerox N40 | Xerox DC255 |
| Xerox N-2125 | Xerox 4LP |
| Xerox N17 | Xerox 4LP |
| Xerox N40 | Xerox 4LP |
+--------------+-------------+
---------------------------------------------------------------------
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