Simple Sub query

Simple sub query in mysql

"select tname from tzone where tzid=(select tzid from country where cname='india')"
Table tzone having field tname and tzid
Table country having field tzid,cname