sql - More than one value returned by subquery -

i have sub query returns more 1 value.please see query below. there possibility more 1 order exist given customer , date. in case want return 1 order (it might sound strange want accomplish). how set limit? tried set limit 1 in sub query didn't manage make work?

any ideas?

i using teradata

select person.name,  (select order order order.name=person.name , order.date=(select max(date) order order.name=person.name))order person  

as in comment, here's answer:

select person.name,         (select max(order) order         order.name = person.name           , order.date = (select max(date) order                             order.name = person.name)) order person 

note both order , date reserved words in ansi sql. suggest double quote them avoid future problems , improve portability. (e.g "order".)