Simple Sub query

by raveendran 2010-01-29 19:05:07

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

Tagged in:

806
like
0
dislike
0
mail
flag

You must LOGIN to add comments