Interested to Buy Any Domain ? << Click Here >> for more details...
how can i fetch the records of 3 tables with a single select
query,without using join.
- 12 Answers
- 34333 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / kiran kumar.b
select max(sal) as sal from
(select max(sal) as sal1 from emp1
union
select max(sal) as sal2 from emp2
union
select max(sal) as sal3 from emp3)
salary order by sal desc
u can get the max sal from three tables lets try to do this
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is an authorization in sap?
How do you process errors in call transaction method? : abap bdc
can anyone do BDC or BAPI for F-02 and F-04 transactions.If it LSMW also.Kindly let me know.
What is an interactive report?
What is the use of lock objects?
Is it possible to bring select option in module pool screens?
how can you display data say "your name"in sap script without print program or driver program??
Which transaction code can I used to analyze the performance of ABAP program.?
Filter badi and multiple used badi? Will the sequence matter of the badi implementation in case of multiple used badi?
how to track records from data dictionary?
dynamic programming in sap abap
wat is the default file name of BAPI trace?
Does every abap/4 have a modular structure? : abap modularization
Can we create field without data element? If yes, how?
Hello All, Requesting to all user of this site. Please post your Questions in Proper sub Category of chosen category. Some users post the questions in common category whether sub category for that is available ..like some users still post the SAP Script & ALE Related questions in common ABAP Category. Due to this it becomes very difficult to find the topic wise Questions. Please cooperate with the site & to other users. Thanks & Regards Tamseel
