On Sun, Aug 28, 2005 at 08:46:56 +0800,
Tang Tim Hei <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
