查看语言客户状态表上方的表

查看语言/客户/状态表上方的表

不确定这是否是解决此问题的最有效或最优雅的方法。但是我终于想到了一种方法。以下解决方案的问题是无法再对其进行索引。因此，现在想一想如何做到这一点，而不必将其包装在派生表中。

SELECt  x.ID,  x.StatusOrder,  x.LanguageID,  x.ClientID,  x.Other,  MAX(x.Description),  MAX(x.Disclaimer)FROM (  SELECt    Main.ID,    s.StatusOrder,    f.LanguageID,    f.ClientID,    f.Description,    NULL Disclaimer,    Main.Other  FROM Main  JOIN Fact f    ON f.FactID = Main.DescriptionID  JOIN Status s ON s.StatusID = f.StatusID  UNIOn ALL  SELECt    Main.ID,    s.StatusOrder,    f.LanguageID,    f.ClientID,    NULL Description,    f.Description Disclaimer,    Main.Other  FROM Main  JOIN Fact f    ON f.FactID = Main.DisclaimerID  JOIN Status s ON s.StatusID = f.StatusID) xGROUP BY x.ID, x.StatusOrder, x.LanguageID, x.ClientID, x.Other