2008 Jun 03 8:09 AM
hi friends,
i want to retrive the data for Electronic Bank Statement
so i found the tables
header tabel------- febko
items table -
febep
management records---- febvw
i want to join these tables to retrive the data
how can i join these tables ?
and what is the relation among the tables?
thanks & regards
srinivas
2008 Jun 03 8:47 AM
hi sri,
hope it helps.
these tables have fields in common.
in febrw: anwnd, absnd, azidt are primary key,
in febep : kukey and esnum are pkey,
in febko: anwnd, absnd, azidt,emky are pkey but it also has a field Kukey.......
so with these common fields between them you just join them with for all entries
reward if useful.
regards,
srishti
hi friends,
i want to retrive the data for Electronic Bank Statement
so i found the tables
header tabel------- febko
items table -
febep
management records---- febvw
i want to join these tables to retrive the data
how can i join these tables ?
and what is the relation among the tables?
thanks & regards
srinivas
2008 Jun 03 8:47 AM
hi sri,
hope it helps.
these tables have fields in common.
in febrw: anwnd, absnd, azidt are primary key,
in febep : kukey and esnum are pkey,
in febko: anwnd, absnd, azidt,emky are pkey but it also has a field Kukey.......
so with these common fields between them you just join them with for all entries
reward if useful.
regards,
srishti
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |