我正在學習使用 Northwind 資料庫的 MYSQL FULL JOIN 查詢。這是我的查詢，
SELECT customers.CompanyName, orders.OrderID
FROM customers
FULL JOIN orders ON customers.CustomerID=orders.CustomerID
ORDER BY customers.CompanyName;
客戶表架構，
CREATE TABLE `customers` (
`CustomerID` varchar(5) NOT NULL,
`CompanyName` varchar(40) NOT NULL,
`ContactName` varchar(30) DEFAULT NULL,
`ContactTitle` varchar(30) DEFAULT NULL,
`Address` varchar(60) DEFAULT NULL,
`City` varchar(15) DEFAULT NULL,
`Region` varchar(15) DEFAULT NULL,
`PostalCode` varchar(10) DEFAULT NULL,
`Country` varchar(15) DEFAULT NULL,
`Phone` varchar(24) DEFAULT NULL,
`Fax` varchar(24) DEFAULT NULL,
`Image` longblob,
`ImageThumbnail` longblob,
PRIMARY KEY (`CustomerID`),
KEY `City` (`City`),
KEY `CompanyName` (`CompanyName`),
KEY `PostalCode` (`PostalCode`),
KEY `Region` (`Region`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
訂單表架構，
CREATE TABLE `orders` (
`OrderID` int(11) NOT NULL AUTO_INCREMENT,
`CustomerID` varchar(5) DEFAULT NULL,
`EmployeeID` int(11) DEFAULT NULL,
`OrderDate` datetime DEFAULT NULL,
`RequiredDate` datetime DEFAULT NULL,
`ShippedDate` datetime DEFAULT NULL,
`ShipVia` int(11) DEFAULT NULL,
`Freight` decimal(19,4) DEFAULT '0.0000',
`ShipName` varchar(40) DEFAULT NULL,
`ShipAddress` varchar(60) DEFAULT NULL,
`ShipCity` varchar(15) DEFAULT NULL,
`ShipRegion` varchar(15) DEFAULT NULL,
`ShipPostalCode` varchar(10) DEFAULT NULL,
`ShipCountry` varchar(15) DEFAULT NULL,
PRIMARY KEY (`OrderID`),
KEY `CustomerID` (`CustomerID`),
KEY `EmployeeID` (`EmployeeID`),
KEY `OrderDate` (`OrderDate`),
KEY `ShippedDate` (`ShippedDate`),
KEY `ShipPostalCode` (`ShipPostalCode`)
) ENGINE=MyISAM AUTO_INCREMENT=11078 DEFAULT CHARSET=utf8;
這是 MySQL 服務器版本 5.7.35 - MySQL Community Server (GPL)
我正進入（狀態 #1054 - Unknown column 'customers.CompanyName' in 'field list'
有人可以指出我做錯了什么嗎？
uj5u.com熱心網友回復：
mysql不支持全連接，但oracle支持
你可以使用
select customers.CompanyName, orders.OrderID from customers, orders where customers.CustomerID=orders.CustomerID order by customers.CompanyName;
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/362094.html
標籤：mysql