Bad formatting on Join line

[raibeartstewart]

BAD Formatting...the following shoud have the left outer join on the same line, not 2 different lines

FROM TblSkid
RIGHT OUTER JOIN TblDeckLocation
RIGHT OUTER JOIN tblSystemDescriptions_sub
RIGHT OUTER JOIN tbl_ME_Dtls_Cable
LEFT OUTER JOIN tbl_MasterEquipment
ON tbl_ME_Dtls_Cable.Tag_Dest = tbl_MasterEquipment.ME_Id
LEFT
OUTER JOIN tbl_MasterEquipment tbl_MasterEquipment1
ON tbl_ME_Dtls_Cable.ME_ID = tbl_MasterEquipment1.ME_Id
ON tblSystemDescriptions_sub.SD_Sub_Id = tbl_MasterEquipment.ME_SubSystem_ID
ON TblDeckLocation.DL_Id = tbl_MasterEquipment.ME_Deck_ID
LEFT
OUTER JOIN TblSystemDescriptions
ON tbl_MasterEquipment.ME_System_ID = TblSystemDescriptions.SD_Id
ON TblSkid.SkidIDNumber = tbl_MasterEquipment.ME_Skid_ID

[eddie davis]

Thank you for your post into the forum.

I have submitted a bug report to bring this problem to the attention of the development team. The reference for this bug report is SR-827.

The development team will consider the bug report and hopefully implement a fix for the issue in a future version of SQL Refactor.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com