Re: Insert ... Select ???

Article View: dk.edb.database

Article #15237

#15237

From: Bo Larsson
Date: Fri, 15 Jun 2001 14:21

29 lines
1711 bytes

On Fri, 15 Jun 2001 10:09:44 GMT, "stk" <stk.news@kandu.dk> wrote:

>T1:
>GUID   UserID
>xxx     BGATES
>
>T2:
>GUID   FeltNavn     FeltV�rdi
>xxx     UserName    Bill Gates
>xxx     Email          b.gates@whatever
>
>T3:
>UserID    UserName    Email
>BGATES  Bill Gates     b.gates@whatever
>

INSERT T3
SELECT T1.UserID, T2_1.Feltv�rdi AS 'UserName', T2_2.Feltv�rdi AS
'email'
FROM T1 INNER JOIN T2 AS T2_1
ON T1.GUID = T2_1.GUID
AND T2_1.Feltnavn = 'Username'
INNER JOIN T2 AS T2_2
ON T1.GUID = T2_2.GUID
AND T2_2.Feltnavn = 'email'
WHERE T1.GUID = 'xxx'

-- 
Bo Larsson

Technical Details

Message-ID: <3b2b1968.690051601@news.inet.tele.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!TDC-Europe.POSTED!ip88.boanxr13.ras.tele.dk!not-for-mail

References: <_8lW6.1548$hi6.175851@news000.worldonline.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,72179d3b6cccc930
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-15 07:21:13 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!TDC-Europe.POSTED!ip88.boanxr13.ras.tele.dk!not-for-mail
From: Bo Larsson <bo.larsson@postkasse.com>
Newsgroups: dk.edb.database
Subject: Re: Insert ... Select ???
Date: Fri, 15 Jun 2001 16:21:11 +0200
Organization: Posted through some European Outpost of TDC Internet A/S
Lines: 29
Message-ID: <3b2b1968.690051601@news.inet.tele.dk>
References: <_8lW6.1548$hi6.175851@news000.worldonline.dk>
Reply-To: please don't
NNTP-Posting-Host: ip88.boanxr13.ras.tele.dk
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: news.inet.tele.dk 992614869 18666 195.215.222.88
X-Complaints-To: the appropriate department of the poster's provider
X-Newsreader: Forte Agent 1.8/32.548

Reply to Parent Message