Question

请允许我首先指出,由于我不知道如何寻求这一问题,这个问题也可能是重复的。

情况如下:

我有以下两个表格:

Language:

 - LanguageID 
 - Name

以及

Product:

 - ProductID
 - LanguageID
 - Name

表格<代码>Language载有四种语文的4份记录: 英文、法文、意大利文、西班牙文。

The table Product contains 1 record - for a product with a Name "TEST" in English. I would like to do a select on those two tables that will return for every record in the Language table the same product record from the Product table.

So,

LanguageID, Name ,  ProductID, ProductName

1           English 1          Test

2           Italian 1          Test

以及 so on.

任何想法? 感谢任何帮助!

Answer 1

SELECT 
  l.LanguageId,
  l.Name,
  p.ProductId,
  p.Name AS ProductName
FROM Language l
CROSS JOIN Product p

Answer 2

根据我的理解,你想要的是 car产品吗?

SELECT l.LanguageID, l.Name, p.ProductID, p.ProductName from Language l, Product p

这将使你能够把产品和语言结合起来。

Answer 3

is this what you want?

SELECT
    Language.LanguageID,
    Language.Name,
    Product.LanguageID,
    Product.Name
FROM
    Product INNER JOIN Language ON
        Product.LanguageID = Language.LanguageID
WHERE Product.Name =  TEST

友情链接