---
title: "select into........."
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/21659-select-into"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "icaaq"
published: "2001-10-08T19:36:00.000Z"
updated: "2001-10-08T19:57:00.000Z"
replies: 1
views: 139
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/21659-select-into"
---

# select into.........

## #1 — icaaq, 2001-10-08T19:36Z

Nu har jag:

```
strSQL1 = "SELECT F_RF_ID FROM T_FB WHERE F_FB_ID = "&intFbID&""
						Set ObjRS1 = ObjConn.execute(strSQL1)
						intRfID = ObjRS1("F_RF_ID")
						ObjRS1.close
						Set ObjRS1 = Nothing
							'## SQL-sats som lägger in ny post i db		
								strSQL2 = "INSERT INTO T_FORENING(F_USER_ID, F_RF_ID, F_FB_ID, F_FOR_NUMMER, F_FOR_NAMN, F_FOR_IDROTT, F_FOR_KANSLIST, F_FOR_ADDRESS, F_FOR_POSTNR, F_FOR_ORT, " &_
								"F_FOR_EPOST1, F_FOR_EPOST2, F_FOR_TELE1, F_FOR_TELE2, F_FOR_FAX, F_FOR_PGIRO, F_FOR_BGIRO, F_FOR_CLNR, F_FOR_KONTONR, F_FOR_ORGNR, F_FOR_NOT)" &_
								"VALUES("&Session("MMID")&", "&intRfID&", "&intFbID&", "&intNummer&", '"&strNamn&"', '"&strIdrott&"', '"&strKanslist&"', '"&strAddress&"'," &_
								"'"&strPostnr&"', '"&strOrt&"', '"&strEpost1&"', '"&strEpost2&"', '"&strTele1&"', '"&strTele2&"', '"&strFax&"'," &_
								"'"&strPgiro&"', '"&strBgiro&"', '"&strClnr&"', '"&strKontonr&"', '"&strOrgnr&"', '"&strNotering&"')"
```

men jag har för mig att man kan göra en select i insertsatsen, eller är jag ute och cyklar nu :q

Permalänk: https://www.webforum.nu/p/21659

## #2 — LarsG, 2001-10-08T19:57Z

Jo, det går. T.ex. 

```
insert into t(c1,c2) 
select c3,c4 
 from q 
 where c5 in ('a','b')
```

Permalänk: https://www.webforum.nu/p/352757

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/21659-select-into