I have 2 tables:
In the first (A) the following data:
TABLA-A nombre fecha estado ============================== Ariel 12 2 Pablo X 1
Second table (B)
TABLA-B nombre deporte ======================= Ariel Futbol Pablo Basquet
I need you to ask about the first table who has date = X and state = 1, but at the same time know the corresponding sport to this from the other table.
The result would be:
RESULTADO nombre fecha estado deporte ========================================= Pablo X 1 Basquet
I was testing with Inner Join. I know it must be easy but something is blocking me. I would greatly appreciate your help.