2006 Aug 11 4:01 PM
These are my tables:
eban,
ekbe,
eket,
ekko,
ekpo,
likp,
makt,
mara,
marc,
marm,
mbew,
mdpb,
mdrs,
mvke,
plaf,
zapodata_mth,
s742,
t179t,
t460a,
zbw_eod,
zcopk,
zendbald,
zendproj,
zflashs,
zgblh,
zprdsched,
zschd,
vbbe,
t179.
The problem is, I need to do a report using all these tables... what's the best way to match them? Please advise and thanks in advance.
These are my tables:
eban,
ekbe,
eket,
ekko,
ekpo,
likp,
makt,
mara,
marc,
marm,
mbew,
mdpb,
mdrs,
mvke,
plaf,
zapodata_mth,
s742,
t179t,
t460a,
zbw_eod,
zcopk,
zendbald,
zendproj,
zflashs,
zgblh,
zprdsched,
zschd,
vbbe,
t179.
The problem is, I need to do a report using all these tables... what's the best way to match them? Please advise and thanks in advance.
2006 Aug 13 7:43 AM
Hi Pom,
Use the primary key relation between tables and retrieve the data using innerjoins and you can also use condition types.
Reward Points if helpful.
Regards,
Harini.S
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |