Inner join

[Former Member]

Hi,

Lets suppose, i have made inner join on three tables, a, b & c. I have mentioned the fields which i need to select from tables a and b. But in table c i want to select all fields. is there any way like '*', that without mentioning like c_{f1, c}f2...... the fields, I can select all the fields from table C.

Thanks,

[RichHeilman]

No you can not mix a field list and * together, you have to specific all fields that you want statically, or simply use *

Regards,

Rich Heilman

[Shafiq_Rehman1]

I just tried that, it was an interesting question. I dont think there is a way to put * like that.

You can do it in open SQL, but putting "TableName.*" in joins.

[Former Member]

Hi ,

step 1) select * from c into itab1

step 2) then write a inner join b & c and put it into other internal table

step 3) loop at itab1

read statement from itab2

endloop

Regards

Sreeni