Bad formatting on Join line

Refactors and formats SQL code.

Bad formatting on Join line

Postby raibeartstewart » Wed Nov 12, 2008 3:33 pm

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
raibeartstewart
 
Posts: 3
Joined: Mon Sep 08, 2008 2:19 pm

Postby eddie davis » Fri Nov 14, 2008 6:22 pm

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
eddie davis
 
Posts: 998
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Refactor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron