How to run sql query inside sql loop

[aru]

I need to run a program and display the information.

I have a table called Country. fields are
ID
Name.

ID Name
us United States
uk United Kingdom
ind India
esp Spain

I am using ID of country in 'sales' table

say Table 'sales'. fields are
ID,
Amount,
Country.

ID Amount Country
1 10,000 us
2 20,000 ind


I want to display the full country name in the display.

So I called an SQL in a loop.

And then I want to call another sql with that country_id to get Country name

Is it possible?.

Please See the Attachment



sign0085:

 

[Erel]

It can be done with a single join query:

str = "SELECT sales.ID, sales.Amount, Country.Name FROM sales, Country where lower(sales.Country) = lower(Country.ID)"

Note that the lower function is required because the countries case is not consistent in your database.