st_intersection; What Im doing wrong?

Question

Im trying to run this query :

create TABLE data.agri_grc as select
id, code_00,
ST_Intersection(data.agri.geom,data.grc_bor.geom) as geom from
data.agri;

But im getting this error:

ERROR:  missing FROM-clause entry for table "grc_bor"
LINE 3: ST_Intersection(data.agri.geom,data.grc_bor.geom) as geom fr...

Whats I am missing?

In postgis2 db

Answer 1

@Mapperz Link pointed me to the right direction.

The correct SQL query seems to be :

create table data.agri_grc as select
 a.id, 
 a.code_00,
 ST_Intersection(a.geom,b.geom_3035) as geom from
  data.agri as a, 
  data.grc_bor as b;

you need to put the arguments as table aliases

Answer 2

Try to put the entire SELECT clause in (...)