|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Grouping data...help...
Well, I have database like this...
[League],[Team A],[Team B]...[n] A xxx yyy A xxx yyy A xxx yyy B xxx yyy B xxx yyy B xxx yyy C xxx yyy C xxx yyy C xxx yyy ...and want to display results like this A --------- xxx yyy xxx yyy xxx yyy B --------- xxx yyy xxx yyy xxx yyy C --------- xxx yyy xxx yyy xxx yyy ...anyone got the idea...can help me? Thanks! |
|
#2
|
|||
|
|||
|
RE: Grouping data...help...
look at ORDER BY sql statement. your query should look smth like:
Code:
SELECT league, team_a, team_b FROM table ORDER BY league and whenever the league changes from row to row, you print row header.. |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Grouping data...help... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|