Miguel,
No subquery needed
SELECT e.name, c.telephone FROM employee e LEFT JOIN contact c ON c.id = e.id WHERE e.sex = 'F'
"LEFT JOIN" means there does not have to be a matching contact row to find an employee row, but if there is a matching row, the data will be returned.
I just guessed at what columns you were interested in, and assumed that id was the foreign key between employee and contact.
David
Miguel Loureiro wrote:
Hello, i'm new in this.... I have 2 related tables, how can I see same data from main table ( simple where clause ) and if exists data from related table show it.......confused??
Main table: Employee: id, name,sex,age
Related table: Contact:id,telephone,employee
I want to see all female employees and, if exists the respective contacts...
Thanks 4 your help
Best Regards
Miguel Joaquim Rodrigues Loureiro
- Software Development * Internet Solutions -
<http://www.hlink.pt>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
