MySQL Forums
Forum List  »  Newbie

inner join with null values
Posted by: Sami Tarawneh
Date: September 13, 2016 09:50AM

Hi all

i'm new in MySQL, so please advice
i have two tables :
employee (id,address)
1 karak
2 amman
3 zarqa
4 irbid

code(id,phone)
1 0790000000
2 0795555555

i want to write an sql to return all records from employee and add phone field to them, select * from employee,code where emplyee.id=code.id gives me only the records of employee who has phone. i want all of them to be displayed.

Options: ReplyQuote


Subject
Written By
Posted
inner join with null values
September 13, 2016 09:50AM
September 13, 2016 11:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.