Skip to Content
0
Dec 17, 2012 at 12:51 PM

inner join with multiple times the same fieldname.

1149 Views

hello,

i have a screen in my web dynpro where there are multiple fields that are search parameters. these are not required.

the data that i need to show is from 8 different tables and need to be filtered with the search parameters.

in the list of data that i need are also multiple fields with the same fieldname and from the same table.

the best way to get the data out of the 8 tables is by a inner join, i think?

but how can i do this if i need multiple times the same fieldname and also filter on the searchparameters?