= and IN is based upon Parameters and Select-options. In the second query, we are not using parameters and select-options. We are passing the First Internal table order number data as a input to Order number column of second table.
Hello sir, I've written the FOR ALL ENTRIES code for 4 tables. But in my server there is no data in table. So I just want to check my code. Can I send it to you? or do I upload that code here?
Hello Anirudh - Just Think a Scenario in which someone deleted the order number 4 from Header Table, but did not delete Order Number 4 from Item Table. So by the logic written by you - Second query will return Order Number 4 and it is a wrong result , but If we fetch based upon Header, 4 will never appear in the output, as it is not in the header table.
@@sapabapbyrahulmehta oh ya ✌🏼 thanks bro. Am from CSE background am applying for jobs with 3yrs fake experience ....after watching all your videos can I clear interviews ?🥲
Keep doing it, very good videos....
Thank you.
Your videos are very helpful to me sir. Keep doing
Thank you bhai.
In second table equal to operator can accept single value but how it is considering 3 values cannot we use in operator here
= and IN is based upon Parameters and Select-options. In the second query, we are not using parameters and select-options. We are passing the First Internal table order number data as a input to Order number column of second table.
Hello sir, I've written the FOR ALL ENTRIES code for 4 tables. But in my server there is no data in table. So I just want to check my code. Can I send it to you? or do I upload that code here?
bro y cant we just write "where ono IN s_ono" in 2nd table becoz s_ono also 1,2,3 and lt_data-ono also 1,2,3
Hello Anirudh - Just Think a Scenario in which someone deleted the order number 4 from Header Table, but did not delete Order Number 4 from Item Table. So by the logic written by you - Second query will return Order Number 4 and it is a wrong result , but If we fetch based upon Header, 4 will never appear in the output, as it is not in the header table.
@@sapabapbyrahulmehta oh ya ✌🏼 thanks bro. Am from CSE background am applying for jobs with 3yrs fake experience ....after watching all your videos can I clear interviews ?🥲
did you cleared?
@@anirudhreddy8756