Incorrect Syntax

This is a discussion on Incorrect Syntax within the Microsoft SQL Server forums in category; Can someone please assist with this? I am getting a Incorrect syntax near keyword 'FROM'. I appreciate any help at all. SELECT dbo.LOADRATE.REF_NUMBER, dbo.LOADRATE.RATE_TOTAL AS 'PAID AMNT', dbo.LOADTYPE.DESCRIPTION AS 'MODE', DESCRIPTION1 = CASE WHEN dbo.RATETYPE.DESCRIPTION = FLAT THEN 'LINEHAUL' WHEN dbo.RATETYPE.DESCRIPTION = MILES THEN 'LINEHAUL' ELSE dbo.RATETYPE.DESCRIPTION FROM (dbo.LOADRATE INNER JOIN dbo.RATETYPE ON (dbo.RATETYPE.LOADTYPE_NO = dbo.LOADRATE.LOADTYPE_NO) AND (dbo.LOADRATE.RATE_TYPE = dbo.RATETYPE.RATE_TYPE)) INNER JOIN dbo.LOADTYPE ON dbo.LOADRATE.LOADTYPE_NO = dbo.LOADTYPE.LOADTYPE_NO WHERE dbo.LOADRATE.TRAN_TYPE = 'R' ORDER BY dbo.LOADRATE.REF_NUMBER...

Go Back   Database Forum > Microsoft SQL Server

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 06-26-2008, 03:04 PM
Default Incorrect Syntax

Can someone please assist with this? I am getting a Incorrect syntax near keyword 'FROM'. I appreciate any help at all.

SELECT dbo.LOADRATE.REF_NUMBER,
dbo.LOADRATE.RATE_TOTAL AS 'PAID AMNT',
dbo.LOADTYPE.DESCRIPTION AS 'MODE',
DESCRIPTION1 = CASE
WHEN dbo.RATETYPE.DESCRIPTION = FLAT THEN 'LINEHAUL'
WHEN dbo.RATETYPE.DESCRIPTION = MILES THEN 'LINEHAUL'
ELSE dbo.RATETYPE.DESCRIPTION
FROM (dbo.LOADRATE INNER JOIN dbo.RATETYPE ON (dbo.RATETYPE.LOADTYPE_NO = dbo.LOADRATE.LOADTYPE_NO)
AND (dbo.LOADRATE.RATE_TYPE = dbo.RATETYPE.RATE_TYPE))
INNER JOIN dbo.LOADTYPE ON dbo.LOADRATE.LOADTYPE_NO = dbo.LOADTYPE.LOADTYPE_NO
WHERE dbo.LOADRATE.TRAN_TYPE = 'R'
ORDER BY dbo.LOADRATE.REF_NUMBER
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:24 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.