Need help in joining tables

Hi all,

 

I was having trouble with joining tables (sometimes working with other table, sometimes not) I hope someone could help me this;

I was joining two feature tables together (Oracle database properties not Oracle spatial) using Bmap join capability but it was unfortunate to me that i was not able to get result out of the join.

Both two tables have a common column fields and values, although during the process it successfully joined but when I analyze the result the additional columns and values are missing. To make sure that I dont have any problem with my setup, I tried joining the table using the old joining process in Visual Query Builder and it works. I also noticed in the Data browser the column are there but with empty values.

Wondering how is this happened.

BM 08.11.07.113

Jun

Parents
  • Hi Jun,

    Can you said what is origin of your second table (oracle, shp, dgn xfm, etc...) ?

    In which do you join table ? I mean here which feature property is on left side and on right side ?

    Once joined, are you able to see properties values in analyze window ?

    Please send me the complete request text (Landuse.OID = ECPK_LANDUSE.OBJECTID) ?

    Thank you!

    Sebastien


    This is a test

Reply
  • Hi Jun,

    Can you said what is origin of your second table (oracle, shp, dgn xfm, etc...) ?

    In which do you join table ? I mean here which feature property is on left side and on right side ?

    Once joined, are you able to see properties values in analyze window ?

    Please send me the complete request text (Landuse.OID = ECPK_LANDUSE.OBJECTID) ?

    Thank you!

    Sebastien


    This is a test

Children