Skip to Content
0
Former Member
Nov 02, 2012 at 09:54 AM

Matrix

27 Views

hi

I have 2 tables . One tabel has fields Code,Name . Second table has fields Code,Name,U_Amt

I want to display matrix which should display all Code,Name from first table and U_amt of second table against the first table Code in the 3rd column.

Data is like this

First Table

A01 TypeA

A02 TypeB

Second Table

A01 A01 100

A02 A02 500

So matrix should be like this

A01 Type A 100

A02 Type B 500

Thanks