|
||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread |
| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
||||||
|
|
|
LinkBack | Thread Tools | Search this Thread |
10-05-2007, 07:10 PM
|
|||
|
|||
ANY dialect question:
Left-OuterJoin selecting only the first of 0-to-2 matching rows on the rightI have two tables to be left outer joined because there are zero-to-two matching rows on the right table, and I want to preserve the unmatched left-table rows. An additional wrinkle is that I only want to keep the first row matched in the right table for those having two rows.
    
|
|
Be the first to answer this question! Click on the 'Post Reply' button below.
|
