in reply to Extracting values from one table and feed the values as a query for second table
There's something backwards about table 2. The number of records is constant, expect when a new type of account is encountered, but the database schema needs to change every time you add or drop a person. Should be the other way around.
As Occam said: Entia non sunt multiplicanda praeter necessitatem.
|
|---|