Brent,
Are you wrapping your query like:
DATA "select * from (select ROW_NUMBER() OVER (order by code) as id,
code, sci_name, com_name, lower(family_com)||' ('|| family_sci||')' as
Family, point from rdb.species_master s, maps.null_point p where code in
(select distinct species from
Hi,
I'm getting an error with an SQL in a mapfile.
The query works from from the command line:
select ROW_NUMBER() OVER (order by code) as id, code, sci_name, com_name,
lower(family_com)||' ('|| family_sci||')' as Family, point from
rdb.species_master s, maps.null_point p where code in