Bad formatting on Join line
raibeartstewart
Posts: 6
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
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
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com