Queries in several tables only one column, FK, PK

0

For the query for example of the activity in the calendar table, we can also do it in the table Participant no? to be dragging from calendar to activity and then participant

    
asked by user7407723 19.06.2017 в 04:38
source

1 answer

1

The question is not very clear, but if you mean that if it is possible to omit the board of the table Actividades it would only suffice with:

SELECT * 
FROM Calendario 
INNER JOIN Participantes 
ON Actividad=ParticipanteActividad;

Since both Calendario and Participantes are related through the Actividad .

    
answered by 19.06.2017 / 06:46
source