JackkG
01-23-2015, 01:29 PM
Hi,
Can you help me out with this query below. I wanted to list all the data from "List" sheet into the Test2 sheet. But the criteria is what I'm stuck up with.
Here I want to select all the columns mentioned in the Select statement, where unique instance of CIDs listed in Test sheet will be equal to all the multiple instances of CIDs in List sheet.
sSQL = "Select " & _
"[Author], [Collection], [Ticker], [Pdate], [DocID], [CID]" & _
" From [Test$] Where" & _
" [Test$].[CID] =
[List$].[CompanyID];"
Can anyone help me out with the query, how the Select statement will be?
Thanks!
Can you help me out with this query below. I wanted to list all the data from "List" sheet into the Test2 sheet. But the criteria is what I'm stuck up with.
Here I want to select all the columns mentioned in the Select statement, where unique instance of CIDs listed in Test sheet will be equal to all the multiple instances of CIDs in List sheet.
sSQL = "Select " & _
"[Author], [Collection], [Ticker], [Pdate], [DocID], [CID]" & _
" From [Test$] Where" & _
" [Test$].[CID] =
[List$].[CompanyID];"
Can anyone help me out with the query, how the Select statement will be?
Thanks!