Having trouble in executing this statement - using Nested Select

[mutaher]

geography(name, region, area, population, gdp)

Table Name = Geography
Column Name = Name, Region, Area, Population, GDP

Help me execute this statement

List the name and region of countries in the regions containing ''burma, 'india'

[debasisdas]

Kindly post what you have tried so far.

[mutaher]

geography(name, region, area, population, gdp)

Table Name = Geography
Column Name = Name, Region, Area, Population, GDP

Help me execute this statement

List the name and region of countries in the regions containing ''burma, 'india'

I wrote the statement like this

select name, region from geography
where name in
(select region from geography where name = 'burma','india')

Which i think is not correct can somebody help me

Thanks

[r035198x]

I wrote the statement like this

select name, region from geography
where name in
(select region from geography where name = 'burma','india')

Which i think is not correct can somebody help me

Thanks

You don't need to nest selects for that

select name,region from geography where region like '%burma%' or region like '%india%'