DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:In-Reply-To:Mime-Version:Content-Transfer-Encoding:Content-Type:Message-Id:Cc:X-Mailer:From:Subject:Date:To;
	b=ygw4ZSVDGHISMByZyD3Bv5wSHfVo2mRczNkFR2ns4aXfi7FmciENaPRTZBH9l0Smjc56e04yhSPV+hnFYCc4vlAj18m5DjqCh7SdqAnxaH7nybHxzVfa9NhPQK3hCFTW9K3VmIEeiAj6xprAvMeyhSePQWaRTi1qviMJN0H8EQs=
	;
References: <1328159813393-5449642.post@n5.nabble.com>
In-Reply-To: <1328159813393-5449642.post@n5.nabble.com>
Mime-Version: 1.0 (1.0)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii
Message-Id: <59D2E8F6-962D-4DDC-96C0-5985AE0F4D9A@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: Multiple tables query on Mapserver
Date: Thu, 2 Feb 2012 00:22:46 -0500
To: tiplip <chengwei02@gmail.com>

On Feb 2, 2012, at 0:16, tiplip <chengwei02@gmail.com> wrote:

> Hi all,
>=20
> I have a couple of tables with same structure but standing for different
> layers(1,2,3...) respectivle for Mapserver,
>=20
> table1
>        gid    |  id    | name      | address        | post code  | layer  =
=20
> |  geom
> -----------+------+----------+-------------+-----------+--------+---------=
---
>        1          1       'name11'      'address11'          102356       1=
     =20
> geom11
>        2          2       'name12'      'address12'          102356       1=
     =20
> geom12
>        -          -        'name1-'      'address1-'          102356     =20=

> 1       geom1-
>=20
> table2
>        gid    |  id    | name      | address        | post code  | layer  =
=20
> |  geom
> -----------+------+----------+-------------+-----------+--------+---------=
---
>        1          1       'name21'     'address21'          102356       2=
     =20
> geom21
>        2          2       'name22'     'address22'          102356       2=
     =20
> geom22
>        -          -        'name2-'     'address2-'          102356       2=
     =20
> geom2-
>=20
>=20
> table3
>        gid    |  id    | name      | address        | post code  | layer  =
=20
> |  geom
> -----------+------+----------+-------------+-----------+--------+---------=
---
>        1          1       'name31'      'address31'          102356       3=
     =20
> geom31
>        2          2       'name32'      'address32'          102356       3=
     =20
> geom32
>        -          -        'name3-'      'address3-'          102356     =20=

> 3       geom3-
>=20
>=20
> I want to get query results from table1, 2, 3... if key word matches, say
> name like 'name' as follows:
>=20
> input 'name', results will be like
>=20
> table2
>        gid    |  id    | name      | address        | post code  | layer  =
 =20
> |  geom
> -----------+------+----------+-------------+-----------+---------+--------=
----
>        1          1       'name11'      'address11'          102356       1=
     =20
> geom11
>        2          2       'name12'      'address12'          102356       1=
     =20
> geom12
>        3          3       'name21'     'address21'          102356       2=
     =20
> geom21
>        4          4       'name22'     'address22'          102356       2=
     =20
> geom22
>        5          5       'name31'      'address31'          102356       3=
     =20
> geom31
>        6          6       'name32'      'address32'          102356       3=
     =20
> geom32
>        -          -       ---------      ---------           -------      -=
         =20
> -
>=20
>=20
> can I achieve that results with a single query sentence? and how?
> any good ideas will be appricated?
>=20
> thanks
>=20
>=20

The general method is to use "UNION" but not sure about the changing of the g=
id and id values...

David J.=