topic Re: Inner join in Application Development and Automation Discussions

Inner join

Former Member — Mon, 28 Jul 2008 21:02:42 GMT

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,

Re: Inner join

RichHeilman — Mon, 28 Jul 2008 21:09:54 GMT

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

Re: Inner join

Shafiq_Rehman1 — Mon, 28 Jul 2008 21:19:21 GMT

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.

Re: Inner join

Former Member — Tue, 29 Jul 2008 00:30:06 GMT

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