| Subject | SQL: Restrict outer join to a subset |
|---|---|
| Author | tickerboo2002 |
| Post date | 2004-04-19T15:26:45Z |
As title, I'm doing a left outer join to a table, but I only want
potential matches with the table from a subset. i.e.
left outer join orders o
on o.client_id=c.client_id
......where o.OrderPlaced < '04/04/2004'
I can include this condition in the where clause, but that results in
it returning zero rows should orders be empty.
potential matches with the table from a subset. i.e.
left outer join orders o
on o.client_id=c.client_id
......where o.OrderPlaced < '04/04/2004'
I can include this condition in the where clause, but that results in
it returning zero rows should orders be empty.