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.
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
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 :
You data seems to have no common values between the two tables.
Retrieving data ...