[postgis-users] how to use quartum gis to load postgis two tables with join operation, one is with geometry columns, another not.

[sunpeng]

hi, now,i know how to use quartum gis to load a postgres table with gemetry
columns: the table is like:
CREATE TABLE pois
(
   uid integer not null,
   name VARCHAR(128),
   catcode VARCHAR(32)  not null,
   catname VARCHAR(32),
   others VARCHAR(32)
)
WITH (
  OIDS = FALSE
)
;
SELECT AddGeometryColumn('pois', 'location', 4214, 'POINT', 2);

now ,i have another table:
create table DM_POIS_CLUSTER (
   UID                  INTEGER                 not null,
   CLUSTER_ID_0         INTEGER                 null,
   constraint PK_DM_POIS primary key (UID),
   constraint FK_DM_POIS foreign key (UID) references POIS (UID)
);
then ,how to load the following sql result into quartum gis?
SELECT ST_AsText(ST_ConvexHull(ST_Collect(location))) from
pois,DM_POIS_CLUSTER goup by CLUSTER_ID_0 ;

it seems qgis only load a table with geometry column.
thanks a million!

sun peng
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100518/51ad8e89/attachment.html>