Sounds like a natural for UNION:\
SELECT Title, PubDate, Content FROM Table1
UNION
SELECT ArticleTitle, Title, PublicationDate, ArticleText FROM Table2
*
*
*
ORDER BY 2 DESC, !
The corresponding columne in each table must have like datatypes, but
they need not have the same name, size or precision
The ORDER BY comes after the last SELECT and it refers to the columns
by number (or by names in the *first* SELECT)
HTH
At 2:41 PM -0400 7/10/2000, Frank Mamone wrote:
>We have several tables containing articles for our Intranet. What we want to
>do is output one list with all the articles sorted by date regardless of
>what table they came from.
>
>Right now we are grouping them and adding a header on the display page for
>each group. We want to get rid of the headers and produce one list.
>
>Any ideas?
>
>
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
