|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
SQL query
I have two table as follows:
Country Project Name Project_name Continent Project_Duration Language Supervisor It has a one-to-many relationship. A country can have many projects. So in the result I want to display the country with all the details of all the projects in the country,but want to display the country information only once. ANy ideas about the structure of the query? Thanks in advance. |
|
#2
|
||||
|
||||
|
select the fields you want, then just GROUP BY Country, ORDER BY Country.
|
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > SQL query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|