Group Options

[jammer1221]

Hey all,

I have a query that looks like this:

SELECT tags.tag, assets.id FROM tags,  assets WHERE tags.id=assets.id

it returns this...

+---------+----------+
| tags    | id       |
+---------+----------+
| east    | 10       |
| west    | 11       |
| bumper  | 10       |
| coast   | 11       |
+---------+----------+

how do I get it to return this?

+---------+----------+
| tags    | id       |
+---------+----------+
| east    | 10       |
| bumper  |          |
| west    | 11       |
| coast   |          |
+---------+----------+

Let me know if you have questions or if it is just plain impossible?

Thanks for your help!

Matt

 

[r937]

in a word: don't

don't attempt to "prettify" the tabular results produced by a query to "suppress" a "repeated" value

do this in the application layer

r937.com | rudy.ca

 

[jammer1221]

r937-

So is it possible to "prettify" or no? I realize it's a bad habit, but, in the interest of learning I'd like to know...

Thanks,

Matt

 

[r937]

in the interest of saving you a lot of heartache and frustration, the answer is no

r937.com | rudy.ca

 

[DonQuichote]

If you are willing to learn: You could write a stored procedure to do that. But if you are not into stored procedures, this is not the best reason to start learning about them.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[jammer1221]

DonQuichote:

I would love to learn about stored procedures. Do you have any good links?

Thanks,
Matt