Re: Compressing (and indicating) multiple rows
It's possible with some fancy queries or stored procedures, but almost not worth it. Anything you do there would probably end up being more complicated than just joining the two tables together, and having the application code parse the result set and write the application code itself to display the wildcard for multiple tasks.
If you MUST do it at the SQL level, I foresee a subquery in the FROM clause. Not that its bad, but it can be a pain, especially when your focus is on application functionality, rather than writing complex queries. Like I said, probably not worth the headache.
Andrew Simkovsky
More mysql forums (and other databases):
http://www.dbtekpro.com/forums
Brand new! Just post!
Subject
Written By
Posted
Re: Compressing (and indicating) multiple rows
August 26, 2013 12:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.