Join problem

[#1]

Hi,

      I have a Join problem in my application from attached file join is created between g, j, and mapping table but i want a direct join  so please help me on this.

[martin59]

Hi,

Your join can't be great, your values for [GI Vehicle Id] are different between G and MAPPING-JATO-GI.

Are you sure about your datas ?

Hope that helps you

Martin Favier

[martin59]

Hi,

Your join can't be great, your values for [GI Vehicle Id] are different between G and MAPPING-JATO-GI.

Are you sure about your datas ?

Hope that helps you

Martin Favier

[martin59]

Hi,

Your join can't be great, your values for [GI Vehicle Id] are different between G and MAPPING-JATO-GI.

Are you sure about your datas ?

Hope that helps you

Martin Favier

[alexandros17]

If you want to keep separate the G and J tables you can :  table G left join Mapping tables and left J table linking with the result.

If you want an unique table :

Mapping

left join

G

left join

J

[jagan]

Hi,

You data seems to have no common values between the two tables.

Regards,

Jagan.