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' ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster