query statement help

I duplicated my database table layout in access2000 and dumped this query
into the query builder just to see if it came up with any errors. Except it
worked fine. So i am assuming there is something particular in postgres i am
not aware of. Here is my statement:

SELECT 1.entry_time
FROM table1AS 1, table2 AS 2
WHERE (1.subscription_id=2.subscription_id) And 2.user_id=9 And
2.widget_instance_id=159;

Putting this through access gives me the correct records. Putting this into
postgres gives me zero records.

Thanks in advance for any help.

IF emailing a reply, please replace NOSPAM with merk, thanks