Jump to content

DJ_DP

Members
  • Content count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About DJ_DP

  • Rank
    Newbie
  1. Hi, I have to get some columns from two different tables but with those columns are having similar data but naming convention is different, can I re write the sql more simple way; SELECT A AS A, B AS B, C AS C, D AS D FROM ( SELECT A AS A, B AS B, C AS C, D AS D FROM TABLE 123 A CROSS APPLY (SELECT DISTINCT E AS B FROM TABLE 456) B WHERE E >= B Can we simplify this more? Remove cross apply and use where clause instead?
×