Creating a "customers" table where I'd like to have Employees from the employees table assigned to customers

💬 App Building
2

You can have the AI generate it for you.... in other words ask the AI to create a customers table that contains a Primary Key and an employees table that contains the a foreign key by the same name as the primary key in the customers table.
This way multiple employees can be assigned the same customer primary key
select * from customers where (primary key name) = 'primary key value'

1 Like