MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 
Home / Table Joins

A join is a way of searching for something across tables by using shared values to match up the tables. The simplest form is:

SELECT * FROM table1,table2 WHERE table1.id=table2.id;

This yields the complete contents of whichever rows in the two tables share ID numbers. In MySQL, more specific and extensive types of joins exist, including LEFT or RIGHT joins, STRAIGHT or CROSS joins, INNER and OUTER joins, and SELF join.

Joins are very handy and time saving. Using joins MySQL also allows to delete and update records from multi tables in one go.

Table Joins Related FAQs

What-is-difference-between-ON-Clause-and-WHERE-Clause What is difference between ON Clause and WHERE Clause?

How-to-delete-or-update-records-of-multiple-tables-in-one-go How to delete or update records of multiple tables in one go?

How-to-get-record-from-first-table-joining-with-second-table-without-any-active-record-between-them How to get record from first table joining with second table without any active record between them?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.