如何在INSERT INTO语句中创建INNER JOIN？ [英] How do I make a INNER JOIN inside a INSERT INTO statement?

问题描述

您好b $ b

我需要在此声明中进行INNER JOIN我该怎么做？



这个是我到目前为止尝试过的？



当我向用户发送电子邮件时，我希望显示星期一而不是1，这就是为什么我要进入INNER JOIN dage table。

Hi
I need to make a INNER JOIN inside this statement how does I do that??

This is what I have tried so far?

When I send a e-mail to user I want to display Monday instead of 1, so thats why I have to INNER JOIN dage table.

CREATE TABLE [dbo].[ordre_linie] (
    [ordre_linie_id] INT          IDENTITY (1, 1) NOT NULL,
    [antal]          VARCHAR (50) NOT NULL,
    [navn]           VARCHAR (50) NOT NULL,
    [fk_ordre_id]    INT          NOT NULL,
    [fk_kurve_id]    INT          NOT NULL,
    [total_pris]     VARCHAR (50) NOT NULL,
    [fk_dag_id]      INT          NOT NULL,
    PRIMARY KEY CLUSTERED ([ordre_linie_id] ASC)
);

CREATE TABLE [dbo].[dage] (
    [dag_id]   INT          IDENTITY (1, 1) NOT NULL,
    [dag_navn] VARCHAR (50) NOT NULL,
    PRIMARY KEY CLUSTERED ([dag_id] ASC)
);



cmd.CommandText = @"INSERT INTO ordre_linie (SELECT * FROM ordre_linie INNER JOIN dage ON ordre_linie.fk_dag_id = dage.dag_id) 
                                (fk_ordre_id, navn, fk_kurve_id, antal, total_pris, fk_dag_id, dag_navn) 
                               VALUES (@fk_ordre, @navn, @kurv, @antal, @pris, @dag, @dag_navn)";

希望有人能帮助我



/ Tina

Hope someone could help me

/Tina

推荐答案

IpsitaMishra提供了一个样本，但我个人不喜欢在使用JOIN时使用VALUES在你的插入语句中。我建议

IpsitaMishra gave one sample but I personally don't like using VALUES when you have to use JOINs in your insert statement. I would recommend

INSERT INTO Table1 (Field1, Field2)
SELECT a.Field1, b.Field2
FROM TableA a 
INNER JOIN TableB b ON a.ID = b.ID

这个对我们有帮助....



http：// stackoverflow.com/questions/7040390/sql-insert-into-with-select-and-inner-join [ ^ ]





希望：

---------------------

Vishnu Prajapati

This one is Helpful to us....

http://stackoverflow.com/questions/7040390/sql-insert-into-with-select-and-inner-join[^]


Hope :
---------------------
Vishnu Prajapati

CREATE Table #Temp(SON nvarchar(50),ProNo nvarchar(50))

INSERT INTO #TEMP
SELECT SOH.SalesOrderNumber,PP.ProductNumber FROM Sales.SalesOrderDetail SOD (NOLOCK)
INNER JOIN Sales.SalesOrderHeader SOH (NOLOCK) ON SOH.SalesOrderID = SOD.SalesOrderID
INNER JOIN Production.Product PP (NOLOCK) ON PP.ProductID = SOD.ProductID

SELECT * from #Temp

Drop TABLE #Temp

这篇关于如何在INSERT INTO语句中创建INNER JOIN？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！