adspace


How to Join tables on common columns.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1105


What is current version of mysql?

1084


How to Change a users password from unix shell.

1223


Which statement is used in a select query for partial matching?

1247