what is the advantage of left outer join?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database url for mysql?

442


Can you tell how to find the number of rows in a resultset using php?

465


How do we use % when performing a search query?

518


How do you determine the location of mysql data directory?

487


How to Change a users password from unix shell.

564






Is mysql running ubuntu?

479


What is current version of mysql?

453


What are the column comparisons operators?

619


What is blob and clob?

508


How many columns can you create for an index?

479


Can we store pdf files in mysql?

465


What is int mysql?

511


What is a select query?

470


Which statement is used in a select query for partial matching?

606


How do I change directories in mysql?

474