Tang Tim Hei <timheit@netvigator.com> writes:
> Hi,
> I'm new to postgresql. Anytime I type the following command to the database to run, it give me no result record if
table'country' is empty but can get result if 'country' is not empty. Is this so strange?
>
> select A.* from test.currency A, test.country B where A.curr_cd='USD'
You're doing an unconstrained join on "currency" and "country", and if
one of those two tables is empty the result will be empty.
-Doug