SQL Join Command

0
335

sqltuts

Join Command is basically used to get the data from different tables using a single query into a single table.

A user can use JOIN Command in SELECT, UPDATE and DELETE statements in order to join MySQL tables. The following example is of LEFT JOIN also which is different from simple MySQL JOIN.

Using Joins at Command Prompt:

An Example discussing two tables tcount_table and tutorials_person, in Database TUTORIALS. Following is the code is for how to use JOIN command

Example:

 

An SQL query to join these two tables.

Example of Using Joins in PHP Script:

Previous articleSQL AND & OR Operators
Next articleSQL NULL Values
Hello Itsourcecoders, welcome to itsourcecode.com. I'm Joken Villanueva, MIT a passionate Blogger, Programmer and a Hobbyist. I started Itsourcecode because I wanted to give back and Share all the learnings and knowledge I've learned in my career and I believe through this website I would be able to help and assist those newbie programmers in enhancing their skills from different programming languages. So let us all help each other by sharing our ideas!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.