Free for PREMIUM members
[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now
Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.
;with cte as (
select t1.OrgID,t1.OrgName,t2.EmpID,t2.LastName+','+t2.FirstName CustomerName
from Table1 t1
join Table2 t2
on t1.OrgID = t2.OrgID),
cte1 as (
select row_number() over (order by OrgID,EmpID) rn,
select OrgID,0 EmpID,OrgName from Table1
from cte) t1)
select * from cte1
order by rn
Open in new window
Author Closing Comment
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!