On Sun, Aug 28, 2005 at 08:46:56 +0800,
Tang Tim Hei <timheit@netvigator.com> wrote:
>
> In the above command, I just add another table reference to it and it gives me two different results.
> Even I add columns like B.* to it, it do the same things too. Is it not consistance?
> In real world, I don't know the 'country' table is empty or not.
> Sometime it is empty and sometime it is not empty, this will confuse me whether my program has bug or not.
You might want some sort of outer join in that case.