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.