Missing data in column one of libreoffice firebird query

I Am Using Libreoffice Base With Firebird Data Base Engine

In This Consultation Rows Missing With Data From Column One, What Do I Do To Miss The Lacking Data? But Do You Still Appear The Data In Column Two And Three?

multiples listas.odb
image description

Please avoid capitals, on the net it’s like shout, and that’s no needed.

What data miss?

What data miss? Missing data from column one, you need to open the attached file so you can see the problem, and see the only query generated from three tables.

Yes, I see all ok… you look your query:


I think what you want it’s
image description

What’s the difference between LEFT, RIGHT, INNER, OUTER, JOIN?