7.schemabinding testcode.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 7 行

SQL
7
字号
SELECT c.CustomerFirstName + ' ' + c.CustomerLastName AS CustomerName, 
c.AccountNumber, fp.ProductName, cp.AmountToCollect, cp.Frequency, 
cp.LastCollected 
FROM CustomerDetails.Customers c
JOIN CustomerDetails.CustomerProducts cp ON cp.CustomerId = c.CustomerId
JOIN CustomerDetails.FinancialProducts fp ON fp.ProductId = cp.FinancialProductId

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?