Jump to content

Anyone using JOINS in SQL?


Kaushik

Recommended Posts

The JOIN command in the SQL is a powerful too to combine the results from multiple tables into a single view. This is very useful when you want data from two tables having a common column or without any common columns. There is INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN which serve different purposes. I was wondering if anyone uses JOINS in their day to day work or in any specialized projects.

Link to comment
Share on other sites

On 12/14/2018 at 2:38 PM, Kaushik said:

The JOIN command in the SQL is a powerful too to combine the results from multiple tables into a single view. This is very useful when you want data from two tables having a common column or without any common columns. There is INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN which serve different purposes. I was wondering if anyone uses JOINS in their day to day work or in any specialized projects.

Lets look at the practical scenario -

Many of the coders or developers, today, that can actually have used SQL work on pre-built CMS - WordPress, Magento, Opencart or even anything that might have been developed by their organization. And these CMS Apps normally dont have a necessity to code the SQL instructions.

Having said that, there are definitely some Custom PHP sites that would need complex SQL queries for their Databases - but practically, many of the coders who would use those Joins might not be here on the forum.

I think the JOINs are best used in Apps where there is some kind of Analysis that needs to be done with the data in the Database. And definitely, these are tricky to use for newbies and chances of getting them wrong at the first go are higher. I remember when I was learning this SQL, I did take many days to get a hold of these JOINs but now, I think with age, I am much better with them.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...