quick question. i have 2 tables.
Client Table: ClientID INT PK AI, ClientName VarChar
Folders table: FolderID INT PK AI, FolderName VarChar, client_ClientID INT
The issue i have is that i have created this virtual folder appliaction in the site and have created it now where when they register it creates a folder in the folders table called ClientDocs.
However there are 1000 existing clients who need this default foldername created associated to their clientID
how can i run an insert into the folders table with all the existing clientID's from the clients table to save them doing this manually themselves?
so clientid from cleints table must insert into folders table along with the default foldername 'ClientDocs'.
as i said i have it now when they register it creates this insert however i need to run a query on the database for the existing clients.
many thanks in advance.