Hi.
On Sun 2002-07-28 at 17:58:36 -0700, [EMAIL PROTECTED] wrote:
> hello,
>
> i have a couple of questions about my SQL query.
>
> 1. if i want all rows in table 1 that may or may not have a counterpart
> row in table 2, i use LEFT JOIN. this is HORRIBLY slow! why? if i make it
> a simple joi
Erick,
Monday, July 29, 2002, 3:58:36 AM, you wrote:
EP> i have a couple of questions about my SQL query.
EP> 1. if i want all rows in table 1 that may or may not have a counterpart
EP> row in table 2, i use LEFT JOIN. this is HORRIBLY slow! why? if i make it
EP> a simple join (i.e., without th