I have a file that looks like:
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr m0 m1 m3 m4 in sy cs us sy id
0 0 0 1888 776 4 109 65 6 2277 0 3771 0 0 0 0 625 2371 1162 16 12 72
It was built from vmstat for...
I am having an issue with a left join where I will not get any results back, however, if I change the columns I am selecting I do get results back.
select a, b
from table_1, table_2, table_3
where (table_3(+) = table_2
and table_2 = table_1)
and (a = 'a'
and b = 'b'
and c = 'c')
no rows...
When creating an append query, you can specify the Controller
ActiveDocument.Sections["Query"].AppendQueries[1].UnionController=bqUnion
ActiveDocument.Sections["Query"].AppendQueries[1].UnionController=bqUnionAll
However I cannot find how to specify Intersect or Minus...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.