Good day everyone. Im a newbie in sql. I know the usage of the four common commands in sql. Select-choose the needed data
From-where the select is done from the table
Where-criteria
Order-asc or desc
Correct me if im wrong.
So then when do we use inner joins? And if the question needs an amount balance between say 8000 to 12000, would the statement be
WHERE Balance between 8000 and 12000? Help needed. Tq.