Hi,
Note that if you are using a condition on a t_boxdaily field in the
where clause, i think that your "left join" will not take the desired
effect.
If there is a record in table t_fund that it's not in t_boxdaily then
the t_boxdaily fields would appear in the result with NULL values
(because
You are passing a string to compare to a date. If you do this, pass it
in the string format.
Other wise " and t_boxdaily.boxdate < 19990101 "
Steve Briant wrote:
>Hi,
>
>I think I may have spotted a bug in connection with the LEFT JOIN statement.
>
>The following SQL
>
>select name, sum(
Is the date read the same with or without the dashes?
-Original Message-
From: Steve Briant [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 9:17 AM
To: [EMAIL PROTECTED]
Subject: BUG using left join.
Hi,
I think I may have spotted a bug in connection with the LEFT JOIN statemen
