Follow this topic

Last answered:

28 Aug 2023

Posted on:

25 Aug 2023

0

ON THE SYNTAX PICTURE

in SQL / INNER JOIN - Part I

Why is he using the JOIN keyword instead of the INNER JOIN keyword? thanks

nk you

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

28 Aug 2023

0

Hi Geovani!
Thanks for reaching out.

Actually, both are equivalent. The JOIN=INNER JOIN statement.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

0

6

Resolved: Video syntax is outdated/incomplete. Need to run set @@global.sql_mode... & restart application

0

4

Resolved: syntax error code 1064 for create procedure

0

4

23:44:21 unique key (email_adress) Error Code: 1064. You have an error in your SQL syntax; check the

0

4

Error 1064 - syntax error

1

2

Resolved: The old syntax for joining using WHERE is only similar to inner join?

Nicholas Hausler

1

2

Why not do it in a shorter syntax such as listed below?

0

2

General Question About a Syntax Requirement