Re: [pmapper-users] How can I join a second or third table?

[Siki Z. <si...@ag...>]

Hi Gustavo,

probably you should make a view in the sql server joining the two tables, 
and join the view to your shape file.

Regeards,
Zoltan

On Tue, 7 Dec 2010, Gustavo Insaurralde wrote:

> I have a layer.
>
> I have joined right with one table on a SQL Server db with an odbc
> connection
> But i want to join this with some OTHER table on SQL Server.
>
> This is what I want to do:
>
> The shape is about cadastrial info, and the shape have the IDs of the
> cadastrial areas.
> I have joined with SQL Server to retrieve the "IDsOfOwners" of these
> cadastrial areas.
> Now i want to retrieve (from the owners table) the owners info (Name,
> Adress, etc)
> What´s the best way to do that?
>
>
> ---
> Gustavo Insaurralde
> Analista Programador en Sistemas
> Analista en Informática Aplicada
> Maestro Mayor de Obras
> http://insaurraldegustavo.blogspot.com/
> ------------------------------------------------------------------------------
> What happens now with your Lotus Notes apps - do you make another costly
> upgrade, or settle for being marooned without product support? Time to move
> off Lotus Notes and onto the cloud with Force.com, apps are easier to build,
> use, and manage than apps on traditional platforms. Sign up for the Lotus
> Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>