Difference between JOIN..AS and WHERE..condition for combining tables | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Difference between JOIN..AS and WHERE..condition for combining tables

Hello What is the benefit of JOIN two tables instead of just using WHERE?

14th Feb 2019, 7:41 AM
Bela
Bela - avatar
1 Answer
+ 2
If you use WHERE you will get two separate tables, adding join will merge those two separate tables into one
14th Feb 2019, 8:57 AM
LynTon
LynTon - avatar