How to Join tables on common columns.



How to Join tables on common columns...

Answer / Avneesh Kumar Verma

To join tables in MySQL, use the JOIN keyword followed by the table name and a condition specifying the common column between the two tables. Here's an example: SELECT * FROM Table1 JOIN Table2 ON Table1.common_column = Table2.common_column;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How many threads can mysql handle?

1 Answers  


What happens if null values are involved in expressions?

1 Answers  


What is inner join in mysql?

1 Answers  


Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

3 Answers   TCS,


which version of mysql can't support stored procedure??

3 Answers  


What is the use of procedure in mysql?

1 Answers  


Why do we use the mysql database server?

1 Answers  


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

1 Answers  


What is the latest version of mysql?

1 Answers  


Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

1 Answers   TCS,


How can you handle the –secure-file-priv in mysql?

1 Answers  


How can I see all mysql databases?

1 Answers  


Categories