| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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 |
![]() |
| Thread Tools | |
| Display Modes | |