Member Avatar for Stuugie

Hi All,

Hopefully I don't get too scolded here for this question but I can't commit my mind to answer this as I have been ill and am still not fully recovered. In saying that, I have the following set of tables (see pic) and I need to fill in the table: tblBank_Indicator_List with the IDs from 3 other tables. I started to use the following

update dbo.tblBank_Indicator_List
set Bank_ID=dbo.tblBanks.Bank_ID,Demographic_ID=tblBankDemographics.Demo_ID,Indicator_Type=dbo.tblEconomicFinancialIndicators.BEFI_ID
where

but I have no idea what to place after Where? Can someone guide me proper here while I keep at this myself. I'd really appreciate it.

diaBanks.JPG 67.41 KB
  • 1 Contributor
  • 2 Replies
  • 271 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by Stuugie
Member Avatar for Stuugie

Just tried an insert with the following

insert into dbo.tblBank_Indicator_List(Bank_ID,Demographic_ID,Ind_ID,Indicator_Type
Values(dbo.tblBanks.Bank_ID,dbo.tblBankDemographics.Demo_ID,dbo.tblEconomicFinancialIndicators.BEFI_ID)

but that's not recognizing any of the Values for some reason so that's obviously not the way.

Edited by Stuugie
Member Avatar for Stuugie

Well, after picking at pritaeas's brain and with a little help internally, I have the following which did the job perfectly:

insert into dbo.tblBank_Indicator_List(Bank_ID, Demographic_ID, Indicator_Type)
select b.Bank_ID, d.Demo_ID, f.BEFI_ID
from dbo.tblBanks as b, dbo.tblBankDemographics as d, dbo.tblEconomicFinancialIndicators as f

This issue is resolved.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.