+ 1

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

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

8th May 2020, 5:54 PM
CHUKWUONYE GRACE
CHUKWUONYE GRACE - avatar
4 Answers
+ 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
11th May 2020, 7:11 AM
CHUKWUONYE GRACE
CHUKWUONYE GRACE - avatar
0
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.
10th May 2020, 5:56 PM
Tejas Amit Sheth
0
Inner Join did not work for what I want to do...
11th May 2020, 6:39 AM
CHUKWUONYE GRACE
CHUKWUONYE GRACE - avatar
0
Just use JOIN instead of Inner Join.
11th May 2020, 6:53 AM
Tejas Amit Sheth