topic 2 queries into one in Application Development and Automation Discussions

2 queries into one

Former Member — Sat, 22 Nov 2008 18:47:54 GMT

Hi Gems,

I had wriiten two queries as below. Can somene tell me how do i combine the below 2 quesries into one using table aliasing or any other way?

get the func location

IF NOT IT_BUS[] IS INITIAL.

SELECT TPLNR IWERK

FROM IFLOT

INTO CORRESPONDING FIELDS OF TABLE IT_TECH

FOR ALL ENTRIES IN IT_BUS[]

WHERE TPLNR = IT_BUS-HAUS

AND FLTYP EQ 'C'.

IF IT_TECH[] IS NOT INITIAL.

obtain the Superior Func location(TPLMA) again from IFLOT

SELECT TPLNR TPLMA IWERK

FROM IFLOT

INTO CORRESPONDING FIELDS OF TABLE IT_TECH2

FOR ALL ENTRIES IN IT_TECH[]

WHERE TPLMA = IT_TECH-TPLNR

AND IWERK = P_WERKS

AND FLTYP = 'L'.

Please suggest.

thanks

Dan

Re: 2 queries into one

Former Member — Sat, 22 Nov 2008 18:55:59 GMT

one way can be combining the data of two of your internal tables into one final table.

and then use that table for final query.

Regards

Neha

Re: 2 queries into one

Former Member — Sun, 23 Nov 2008 00:00:07 GMT

Hi Neha Shukla,

Thanks! but I want to AVOID hitting the DB tabe IFLOT twice. Your suggestion still maked me to hit the table once again.

Any alternative idea...?

thanks

Dan

Re: 2 queries into one

Former Member — Sun, 23 Nov 2008 00:34:51 GMT

A sub-query might work, but you would end up with only one internal table.

Rob

Re: 2 queries into one

Former Member — Sun, 23 Nov 2008 00:45:14 GMT

Yes Rob that seems to be helpful. Can you please go ahead how to write that?

Re: 2 queries into one

Former Member — Sun, 23 Nov 2008 18:01:50 GMT

First, check the documentation on SELECT and give it a try. If you still have problems, get back to the forum.

Rob

Re: 2 queries into one

Former Member — Mon, 24 Nov 2008 02:38:34 GMT

Hi,

If you use a sub-query, it may effect the performance. So I think you don't need to combine these two queries.

Regards,

Chris Gu

Re: 2 queries into one

Former Member — Mon, 24 Nov 2008 03:27:10 GMT

better not to write any aliasing

Re: 2 queries into one

Former Member — Mon, 24 Nov 2008 14:13:30 GMT

 
> If you use a sub-query, it may effect the performance. So I think you don't need to combine these two queries.

Chris - do you have an example where a sub-query affects performance poorly?

Rob