incorrect syntax in from clause

This is a discussion on incorrect syntax in from clause within the Microsoft SQL Server forums in category; can anyone tell me where I am messing up? 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 JOIN dbo.RATETYPE ON dbo.LOADRATE.LOADTYPE_NO + '-' + dbo.LOADRATE.RATE_TYPE = dbo.RATETYPE.LOADTYPE_NO + '-' + dbo.RATETYPE.RATE_TYPE AND dbo.LOADRATE JOIN dbo.LOADTYPE ON dbo.LOADRATE.LOADTYPE_NO = dbo.LOADTYPE.LOADTYPE_NO WHERE dbo.LOADRATE.TRAN_TYPE = 'R' The error is Incorrect Syntax near keyword 'FROM'. Any help will be appreciated. Thanks...

Go Back   Database Forum > Microsoft SQL Server

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 06-26-2008, 01:00 PM
Default incorrect syntax in from clause

can anyone tell me where I am messing up?

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 JOIN dbo.RATETYPE
ON dbo.LOADRATE.LOADTYPE_NO + '-' + dbo.LOADRATE.RATE_TYPE
= dbo.RATETYPE.LOADTYPE_NO + '-' + dbo.RATETYPE.RATE_TYPE
AND dbo.LOADRATE JOIN dbo.LOADTYPE
ON dbo.LOADRATE.LOADTYPE_NO = dbo.LOADTYPE.LOADTYPE_NO
WHERE dbo.LOADRATE.TRAN_TYPE = 'R'

The error is "Incorrect Syntax near keyword 'FROM'.

Any help will be appreciated.
Thanks
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 02:09 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.