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 strict mode in mysql?
How to convert dates to character strings?
How can you count the total number of records of any table?
Why is mysql popular?
How large can a mysql table be?
What is mysql cursor?
What is not null in mysql?
What are the benefits of mysql?
How does mysql encrypt passwords?
Can you tell a way to know the number of days between the two given dates in php?
How do I stop a query in mysql workbench?
What are the applications required to support mysql?
Oracle (3253)
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)