HELLO,
What did I do wrong in the following statement it returns no record:
select orders.id, iif(isnull
(clients.name), "Sir/Madam",clients.name) as name ;
from orders,clients ;
where orders.id == clients.order_id ;
into cursor temp
what I am trying to do is if the order has a contact name I will print out the name otherwise just say "sir/madam". thanks.
sherry