Options

Bad formatting on Join line

raibeartstewartraibeartstewart Posts: 6
edited November 14, 2008 12:22PM in SQL Refactor Previous Versions
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

Comments

  • Options
    Eddie DEddie D Posts: 1,780 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.