交叉连接中的语法错误 [英] syntax error in Cross join

问题描述

INSERT INTO Food (FoodID, FoodName, ItemID, ItemName) Select DISTINCT FoodID, FoodName, ItemID, ItemName from Food f CROSS JOIN Item i

推荐答案

如果我错了，请纠正我。你写了

Correct me if i am wrong. You write

INSERT INTO 
Food (FoodID, FoodName, ItemID, ItemName)

这会因为你没有提供任何错误而给出错误value

which will give error as you haven't supplied any value

INSERT INTO 
Food (FoodID, FoodName, ItemID, ItemName)
SELECT DISTINCT FoodID, FoodName, ItemID, ItemName
FROM Item;

这篇关于交叉连接中的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！