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