select from one table with help of another table - Mailing list pgsql-novice

Hi, list,

I’m trying to get the fid (integer) of objects in table line where the geometry (postgis) is inside another geometry from another table (polygon),

But I would not like to get the objects with the highest fid inside the polygons of table buffered.

I’ve tried this:

   SELECT fid FROM

      "line" USING “polugon” AS b WHERE

       ST_Contains(b.geom, "line".geom) AND "line".fid NOT IN (SELECT MAX("line".fid)

);

It complains about “USING” in line 2.

Anyone who knows how I should do it instead?

Kind regards,

Paul