I'm learning how to use OpenOffice Base and I've stumbled upon an error.
Since I've got no idea about SQL nor any database coding yet, I've created a copy, I turned it into a .zip file, went into database and found a scripts file.
The line 13 (where it's supposed to be located the error) has the following:
CREATE VIEW "PeliculasCadaGenero" ( COUNT("Pel\u00edculas"."Id_pel\u00edcula"),"Nombre") AS SELECT COUNT( "Pel\u00edculas"."Id_pel\u00edcula" ), "Generos"."Nombre" FROM "Pel\u00edculas", "Generos" WHERE "Pel\u00edculas"."Generos" = "Generos"."Id_genero" GROUP BY "Generos"."Nombre" ORDER BY "Generos"."Nombre" ASC
I hope someone can help me!
Thanks in advance.
Edit: Attached image since the imgur·com link will eventually break and since the forum doesn't understand WEBP format for display -- MrProgrammer, forum moderator |