Skip to Content
0
Former Member
Nov 29, 2006 at 09:18 AM

Problem in Join using all fields of one table and selected from other

38 Views

Dear All,

I have to use a join on two table KNA1 and ADRC using the adress number field. The problem I want to fetch all the fields from KNA1 and few fields from ADRC table. Do I need to use individual fields in the select query from table KNA1(There are about 170 fields in KNA1). IS there any way to achieve this?

Thanks,

Amit Goyal