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 |
Does insert statement lock the table?
How can we change the name of a column of a table?
What are the differences between drop a table and truncate a table?
How to load data from a text file into a table?
How does mysql store dates?
How does php communicate with mysql?
What is mysql installer?
What is the datatype for password in mysql?
what is constraints? Also explain the different types of constraints?
How do I enable mysqli extension?
what is the main difference between myisam and innodb
How to upload a large file through phpmyadmin in mysql?
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)