query statement help

From: "Ian Lipsky" <NOSPAM(at)pacificnet(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: query statement help
Date: 2000-10-24 00:33:55
Message-ID: TN4J5.18263$rD3.1112617@newsread2.prod.itd.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2000-10-24 01:49:53 Re: rules *very* slow?
Previous Message bmccoy 2000-10-24 00:30:57 Re: How do I find out the version number