Missing data in column one of libreoffice firebird query

[marcosAoo]

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

[mariosv]

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

[mauricio]

What data miss?

[marcosAoo]

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.

[mauricio]

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

SELECT "ONE"."NAME", "TWO"."NAME", "THREE"."NAME" FROM "TWO", "ONE", "THREE" WHERE "TWO"."ID" = "ONE"."ID" AND "THREE"."ID" = "TWO"."ID"

[mariosv]

I think what you want it’s

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