Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-27 : 11:20:54
|
Normand writes "hi, here my problems
i have 2 table first one containing
articleid,link,title, content,sourceid,date_added
second one containing
sourceid,captionEn, CaptionFR
and
here what i want to do
for each given day that i list i want to display one source first
I.e.
sourceid = 44
source caption = "gmn"
how could i display all article that have the source gmn first for each day before displaying all the other articles?
here an example of what i have now
2001-05-21 | |
CD sales surge past £1bn despite Napster (News, Anna Whitney - The
Independent) |
Janet Cardiff: Sixteenth-century surround sound (Interview, Christopher
Wood - The Independent) |
The legacy of Harry Somers (Profile, Tamara Bernstein - National Post)
Today in Music... (News, GMN) |
Orchestra, maestro offer heroic 'Eroica' (Review, Tom Di Nardo -
Philadephia Daily News) |
Wylliams/Henry troupe is exhilarating (Review, Paul Horsley - Kansas
City Star) |
What i want is to be able to put the article that have the source gmn before each other article and this for each date
if you want to check it on the web here the link to ot
http://www.scena.org/index-en.asp
look under Classicalmusicnews.org section" |
|
|
|
|
|
|
|
Ordering