I have this query which works well under Access, but generates a "Incorrect syntax near '>'." error under MSSQL.
I'm not too familiar with MSSQL, can someone tell me what would be the equivalent for the line
"page2.dateMaj > page1.dateMaj AS modif"
and possibly an alternative that would work in both cases?
Thanks.
SELECT
page1.PageId,
page1.titrePageFR AS titre,
page2.dateMaj > page1.dateMaj AS modif
FROM tbl_pages page1,
tbl_pages page2
WHERE page1.PageId=page2.PageId
AND (NOT page1.prov AND page2.prov)
--
_______________________________________
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]