SQL select from multiple tables(two and more)

Description:
Code and details:

mysql join simple example for beginners

http://blog.softhints.com/mysql-join-simple-example-for-beginners/

Frequent SQL commands select

https://blog.softhints.com/frequent-sql-commands-select/


Example Query from 3 tables

SELECT *
FROM girls B, couple C, boys A
where C.boy = A.id
AND C.girl = B.id


Example Query from 2 tables

SELECT *
FROM boys A, girls B
where B.id = A.relation

Example Query from 2 tables with a join

SELECT A.name, B.name
FROM boys A
INNER JOIN girls B
ON A.relation = B.id

Example Query from 2 tables with a join and union

SELECT A.name, B.name
FROM boys A
LEFT OUTER JOIN girls B
ON A.relation = B.id

UNION

SELECT A.name, B.name
FROM boys A
Right OUTER JOIN girls B
ON A.relation = B.id

Example Query from 3 tables with a join

SELECT *
FROM couple d
INNER JOIN boys a ON d.boy = a.id
INNER JOIN girls b ON b.id = d.girl

---------------------------------------------------------------------------------------------------------------------------------------------------------------
Code store

https://bitbucket.org/softhints/

Socials

Facebook: https://www.facebook.com/groups/435421910242028/
Facebook: https://www.facebook.com/Softhints/
Twitter: https://twitter.com/SoftwareHints
Discord: https://discord.gg/KRqxza


If you really find this channel useful and enjoy the content, you're welcome to support me and this channel with a small donation via PayPal.

PayPal donation https://www.paypal.me/fantasyan