Grouping

Hello, my question is how can I get my data to read like this:
Cat Small 10
BIG 5
Dog Small 7
Big 1
Is there a way to only list the main topic once and then the detail can be
indented like so?Yes, there is - on the client where it belongs. :)
You could insert the rows into a temporary table first, update it with a
moderately 'twisted' query and then return the result-set form the temporary
table. But that IMHO would just be plain silly.
Presentation should be handled by the client application.
ML|||Well I am creating an SQL view of the data. Maybe I'm doing a little too
much with my view. I'm creating a view from linking 3 different tables.
Customer Table, Item Table, and Transaction table. I'm trying to list the
data by CustomerNum to list all the transactions in the past 2 years. I
think I am doing something wrong to begin with. Right now my data shows
every instance which I want, but I want the data to look more pleasing (i.e.
listing CustomerNum and info only once and then listing all the transactions
under that).
Any suggestions?
"ML" wrote:

> Yes, there is - on the client where it belongs. :)
> You could insert the rows into a temporary table first, update it with a
> moderately 'twisted' query and then return the result-set form the tempora
ry
> table. But that IMHO would just be plain silly.
> Presentation should be handled by the client application.
>
> ML|||As I've already said - formatting belongs on the client. There's nothing mor
e
"pleasing" than having normalized data. At least IMHO.
Google for the following keywords: tuple, normal form, atomicity,
consistency, relation. <-- the back-bone of SQL.
ML