There are different scenes when we will be using Union / all Union / Intersect / Minus operator in sqr.
below is the example of using union in sqr.

begin-select 
field-a &fld-a 
field-b &fld-b 
from tbl1 
where
union 
select field-c, field-d from tbl2 where
end-select

Views: 214

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service