From: tiplip <chengwei02@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Multiple tables query on Mapserver
Date: Wed, 1 Feb 2012 21:16:53 -0800 (PST)
Message-ID: <1328159813393-5449642.post@n5.nabble.com> (raw)
Hi all,
I have a couple of tables with same structure but standing for different
layers(1,2,3...) respectivle for Mapserver,
table1
gid | id | name | address | post code | layer
| geom
-----------+------+----------+-------------+-----------+--------+------------
1 1 'name11' 'address11' 102356 1
geom11
2 2 'name12' 'address12' 102356 1
geom12
- - 'name1-' 'address1-' 102356
1 geom1-
table2
gid | id | name | address | post code | layer
| geom
-----------+------+----------+-------------+-----------+--------+------------
1 1 'name21' 'address21' 102356 2
geom21
2 2 'name22' 'address22' 102356 2
geom22
- - 'name2-' 'address2-' 102356 2
geom2-
table3
gid | id | name | address | post code | layer
| geom
-----------+------+----------+-------------+-----------+--------+------------
1 1 'name31' 'address31' 102356 3
geom31
2 2 'name32' 'address32' 102356 3
geom32
- - 'name3-' 'address3-' 102356
3 geom3-
I want to get query results from table1, 2, 3... if key word matches, say
name like 'name' as follows:
input 'name', results will be like
table2
gid | id | name | address | post code | layer
| geom
-----------+------+----------+-------------+-----------+---------+------------
1 1 'name11' 'address11' 102356 1
geom11
2 2 'name12' 'address12' 102356 1
geom12
3 3 'name21' 'address21' 102356 2
geom21
4 4 'name22' 'address22' 102356 2
geom22
5 5 'name31' 'address31' 102356 3
geom31
6 6 'name32' 'address32' 102356 3
geom32
- - --------- --------- ------- -
-
can I achieve that results with a single query sentence? and how?
any good ideas will be appricated?
thanks
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Multiple-tables-query-on-Mapserver-tp5449642p5449642.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chengwei02@gmail.com
Subject: Re: Multiple tables query on Mapserver
In-Reply-To: <1328159813393-5449642.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox