Zoho DB (Query) not correctly querying
To test the DB & query I've created 2 tables:
AGENDA (Nombre Text, F_Nacim Date, Cod_Postal Number, eMail email)
Data:
Fer, 11/25/1969, 28823, ppp@gmail.com
Ceci, 12/11/1967, 28823, (nothing)
Sofi, 07/04/2000, 28823, (nothing)
LOCALIDADES (Cod_Postal Number, Localidad Text)
Data
28823, Localidad_Description
Then I've done this select-SQL:
SELECT a.Nombre, a.F_Nacim, a.Cod_Postal, a.email, b.Localidad FROM Agenda a left join Localidades b on b.cod_postal = a.cod_postal order by a.nombre
The query retrieve all the data and just only one of the F_Nacim (date) values, ignoring the two other dates.
Output:
Fer, 11/25/1969, 28823, ppp@gmail.com, Localidad_Description
Ceci, (nothing), 28823, (nothing), Localidad_Description
Sofi, (nothing), 28823, (nothing), Localidad_Description
�Is this DB a beta software?