SELECT
N.intNewsID ID,
N.strNewsTit Title,
N.strNewsGrav Grav,
N.memoNewsContent Content,
N.dtNewsDateInc DateInc,
S.strSiteName SiteName
FROM
tblsite S
INNER JOIN tblnews N ON (S.strSiteID = N.strSiteID)
WHERE S.strSiteID='#siteID#'
AND N.intNewsStatus=1
AND
#PreserveSingleQuotes(booleansearch)#
UNION
SELECT
C.intContentNr ID,
C.strTitle Title,
C.strGrav Grav,
C.memoContnt Content,
C.dtInc DateInc,
S.strSiteName SiteName
FROM
tblcontent C
INNER JOIN tblsite S ON (C.strSiteID = S.strSiteID)
WHERE S.strSiteID='#siteID#'
AND
#PreserveSingleQuotes(booleansearch2)#
ORDER BY DateInc DESC
I'll need the real column name for N.intNewsID ID and C.intContentNr ID.
Thanx in advance.
SWD
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
