What is the difference between left join and left outer join?
- 1 Answers
- 794 Views
- I also Faced
- E-Mail Answers
There really is no difference between a LEFT JOIN and a LEFT OUTER JOIN. Both versions of the syntax will produce the exact same result.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are sql data types?
How do I create a sql database?
What is the difference between view and stored procedure?
Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
What is the use of index in sql?
What is the execution plan in sql?
when is the use of update_statistics command? : Sql dba
What are database links used for?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is primary and foreign key?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
what is difference between stored procedures and application procedures,stored function and application function?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
