Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am a newbie to the MySQL database.I want to know different types of joins in MySQL and any link or any other kind of documentation with examples which will clear the doubts will highly appreciable.

share|improve this question
You should ask a specific question. If you google for MySQL and join you get tons of explanations and examples. – Matteo Apr 7 '12 at 5:27
Try going to Google and search for "MySQL join"...I believe that the official MySQL docs on JOIN syntax is the 2nd result that comes back. – Aaron Apr 7 '12 at 11:21
up vote 1 down vote accepted

Joins are a concept of Relational Algebra, you can find some information on wikipedia. Join is considered an additional operator.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.