what is the advantage of left outer join?
Answers were Sorted based on User's Feedback
Answer / manish kumar
the left outer join can be used whih return all the rows
from the first table,even if there are no matchesin the
seond table
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / tanseer ahmed
left outer join return all matching record + all record of
first table, if there are no matching record then
display only firt table all record
| Is This Answer Correct ? | 7 Yes | 1 No |
What is the maximum connection pool size?
How much does mysql enterprise cost?
What are the advantages of mysql?
How do I clear the screen in mysql?
How do I change global variables in mysql?
How many ways we can we find the current date using MySQL?
What is A BI Ap;plication?
How to connect html form to mysql database using php?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
How show all tables in mysql query?
What is mysqladmin flush hosts?
What does tinyint mean?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)