* Ian Lipsky in "[GENERAL] query statement help" dated 2000/10/24 00:33
* wrote:
> 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.
Change the 1's to a's and the 2's to b's and everything should be fine.
postgres requires table names to start with a letter.
--
really hacks