KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Possible Duplicate: INNER JOIN versus WHERE clause — any difference? What is the difference between an INNER JOIN query and an implicit join query (i.e. listing multiple tables after the FROM keyword)? For example, given the following two tables: CREATE TABLE Statuses( id INT PRIMARY KEY, description VARCHAR(50) ); INSERT INTO Statuses VALUES (1, 'status'); CREATE TABLE Documents( id INT PRIMARY KEY, statusId INT REFERENCES Statuses(id) ); INSERT INTO Documents VALUES (9, 1); What is the difference between the below two SQL queries? From the testing I've done, they return the same result. Do they do the same thing? Are there situations where they will return different result sets? -- Using implicit join (listing multiple tables) SELECT s.description FROM Documents d, Statuses s WHERE d.statusId = s.id AND d.id = 9; -- Using INNER JOIN SELECT s.description FROM Documents d INNER JOIN Statuses s ON d.statusId = s.id WHERE d.id = 9;
Tags (comma-separated)
Save Edits
Cancel