How can we help you today? How can we help you today?

Cross Join

Hi Redgate Team,

It seems that CROSS JOIN is not formatted correctly - it should follow the JOIN formatting style.

[code]
USE AdventureWorks2017;
GO

SELECT TOP 100
    a.SalesOrderID
,    a.SalesOrderDetailID
,    a.CarrierTrackingNumber
,    a.OrderQty
,    a.ProductID
,    a.UnitPrice
,    a.UnitPriceDiscount
FROM
    Sales.SalesOrderDetail a
-- Should look like the INNER JOIN example
CROSS JOIN Sales.SalesOrderDetail b;

SELECT TOP 100
    a.SalesOrderID
,    a.SalesOrderDetailID
,    a.CarrierTrackingNumber
,    a.OrderQty
,    a.ProductID
,    a.UnitPrice
,    a.UnitPriceDiscount
FROM
    Sales.SalesOrderDetail a
INNER JOIN
    Sales.SalesOrderDetail b
ON
    a.SalesOrderID = b.SalesOrderID;
[/code]

Would be nice to see a fix!

Thanks!

Torsten
torsten.strauss
0

Comments

2 comments

Sort by
  • Jessica R
    Hi @torsten.strauss,

    Thanks for your feedback on this!

    It looks like the "Place JOIN keyword on new line" option applies correctly, but the "Place JOIN table on new line"  and "indent JOIN table" options don't.

    I've created an issue for this with internal reference SP-6989 and will post any updates to it here. Thanks again! :)
    Jessica R
    0
  • torsten.strauss
    perfect- thanks!
    Torsten
    torsten.strauss
    0

Add comment

Please sign in to leave a comment.