Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Combine three query together
I have a follow up in the same category, i hope nagornyi can help me with i have a problem with having two sibling groups reporting to one parent. G1 <- G2 <- G3A G1 <- G2 <- G3B I would like to show both of these G3 data next to each other. If i keep them in one group it will create a...- ameima
- Post #10
- Forum: Oracle: Reports
-
Report problem - Help required
if you already have say G_1, G_2 and employee is G_3 Make a group in between for department, the new G_3, (WIth the wizard simply close all the levels when adding fields to each group, then a new level will be created) Employee becomes level 4 now Per each department (G_3) you want to show...- ameima
- Post #3
- Forum: Oracle: Reports
-
More effecient SQL statement
IT depends what you mean with more efficient what you are doing is querying a mulitple joined set of 4 tables a, b,c, d, with three outer joins and one inner join If you want it to run faster, you should use indices on the keys. If you have a buffer problem, you should increase you buffer...- ameima
- Post #4
- Forum: Oracle: Reports
