Try this One

select

* -- What ever column you want

,(case when Customer.CustomerID >3 then Order.PO else Order.OrderID end) as 'PO/OrderID'

from

Customer

inner join CustomerOrders on Customer.CustomerID =CustomerOrders.CustomerID

inner join Order on CustomerOrders.OrderID =Order.OrderID