| group by clause [message #374224] |
Thu, 31 May 2001 03:09  |
uma
Messages: 67
Registered: May 2001
|
Member |
|
|
how to retrieve data from mutiple tables, using group by clause, for example university_name,university_regno
and some other fields in the university table,univesity_name is not there in any other table,
but university_regno is there in one more table.
in this case , can I group the data by university_name ?
Is it necessary to have the same field in all other tables to use it in group by clause.
in this case I just want to group the data according to each univesity.
please answer my query.
thank u.
|
|
|
|
| Re: group by clause [message #374234 is a reply to message #374224] |
Thu, 31 May 2001 13:32  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
|
The group by is applied to the resutset of the query. If you want different groupings, you need to break into different subqueries. Each subquery in the main query can have whatever grouping you choose.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
