-3

Table A

name emp_id

table B

name emp_registration

table C

name_id dateofbirth

These are tables in mysql with column name of A,name of B and name_id of c having same value.How do i join these 3 tbales by the column name?

zinc
  • 81
  • 1
  • 7
  • 1
    Possible duplicate of [How to join two tables mysql?](http://stackoverflow.com/questions/3536283/how-to-join-two-tables-mysql) – Pawel Gradecki Apr 12 '17 at 17:57

1 Answers1

0

consider using left join

SELECT * FROM table1 LEFT [ OUTER ] JOIN table2 ON table1.column_name=table2.column_name;

visit http://www.w3resource.com/sql/joins/perform-a-left-join.php?

rixxkenzou
  • 21
  • 5