Hello Simon, Monday, April 22, 2002, 10:38:12 PM, you wrote:
SR> Good afternoon, SR> I am currently trying to link two tables from MapInfo and don`t seem to find a way to do that. Here is my situation: SR> I have one table that is mappable and contains unique sites locations (ID, X,Y). I also have another table that is not mappable and contains the attributes (many attributes for each location) SR> (ID, fishspecies). I would like to be able to make a selection from my mappable table and ask for example for all fish species called "CACO". How can I do this? SR> Is it possible to link the table (one to many) or can we only join (one SR> to one)? May be like this: select mappable_table.obj from mappable_table, simple_table where simple_table.id = mappable_table.id and simple_table.fishspecies = "CACO" -- Best regards, Vladimir Lashin microOLAP Technologies LLC mailto:[EMAIL PROTECTED] http://www.microolap.com/gis/ - GIS related products --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
