Please is there anyone familiar with the popular DVDRental dataset used in SQL for practice? Syntax enquiry!!!!!!!!!!!!!!

Question

Need CLARITY on Joining more than one table in SQL. What's the Syntax. Need to Brainstorm with someone

Answer 1

I want to connect 2 tables but the primary key of one is not found in the other table as a foreign key. But rather in a different table entirely.... The Join Syntax is not coming simple here

Answer 2

SELECT (columnname) FROM table1 JOIN table2 WHERE

SELECT (columnname) FROM table1 JOIN table2 ON

u cab use these 2 methods or even remove the on and where clauses , that will lead to joining both tables completely
ONLY CONDITION IS.
Both tables should hav same NUMBER OF COLUMNS.

Answer 3

Inner Join did not work for what I want to do...

Answer 4

Just use JOIN instead of Inner Join.