1
I need to select which employees are allocated to which projects but when I run my code:
select projeto.nome, funcionario.nome from projeto, funcionario
it selects all names in all projects and not how they are really allocated. How can I refine this search?
Edit: are organized as follows in 3 tables: allocation.
staff
and project
If something is missing please ask, I started recently in mysql.
Without the structures of the tables it is impossible to suggest any query.
– rray
Good afternoon rafael, first welcome to the community, recommend you do the tour and take a look at the section How to create a Minimum, Complete and Verifiable example
– Alvaro Alves
Rafael, have you solved your problem? what do you want to choose in a combo, what would this combo look like? Will the combo have the name of the project? , employee name? or time , used? , or what you want in reality, is a select showing the employee name + project + time?
– Risk