Hi all,
i have three tables:
table 1 has two colomns: name and id
table 2 has two columns: countrycode and id(id in this table is the forgin key from table one)
table 3 has two columns: countryname and countrycode(countrycode is the forggin key from table two)

now i have to make a query to select the name from table one and the countryname that belongs to that name from table three .
can anyone help me to make this query???

Thanx.

This is rather basic SQL. So rather than supply you with the answer, I am going to let you figure it out yourself. I will give you this link to a "DB2 SQL cookbook" that will help you on your journey.

http://mysite.verizon.net/Graeme_Birchall/id1.html

Andy

Agree with Andy....

You will have look at topics related to JOINS ( INNER | LEFT | RIGHT ) to be more precise.....

Does this mean that the 2nd session of summer school has started?