Select not showing all data

[#1]

Hello guys, I'm a brand new QlikView user, so I thank you in advance for your help.

I'm trying to select all items (PN field) from the table POD and their matches into the tables REC and BOM, in order to show in the report the  PNs, the date the items where requested (NEED DATE in BOM) and the date they where received (RECEIVING_DATE in REC). The problem is the Select is just showing once when there are repeated PNs into POD. It is probably basic, but I cannot find where the error is.

Here is the selects I'm using:

POD:
SQL SELECT
POH_AUTO_KEY,
POD_AUTO_KEY,
NEXT_DELIVERY_DATE,
POH_AUTO_KEY||'-'||PNM_AUTO_KEY as PN_KEY
FROM QCTL."PO_DETAIL";

REC:

SQL SELECT
"ENTRY_DATE"                        AS RECEIVING_DATE,
"POD_AUTO_KEY"
FROM QCTL."RC_DETAIL";

BOM:
SQL SELECT
PNM_AUTO_KEY,
ENTRY_DATE                          AS ITEM_DATE,
NEED_DATE,
ACTIVITY,
SI_NUMBER,
POH_AUTO_KEY||'-'||PNM_AUTO_KEY     AS PN_KEY
FROM QCTL."VIEW_WOBOM"
;

Thank you again.

‌
Marineusa

[#2]

Try this:

POD:
SQL SELECT
POH_AUTO_KEY,
POD_AUTO_KEY,
NEXT_DELIVERY_DATE,
POH_AUTO_KEY||'-'||PNM_AUTO_KEY as PN_KEY
FROM QCTL."PO_DETAIL";

REC:

Load *

where exists(POD_AUTO_KEY);

SQL SELECT
ENTRY_DATE                      AS RECEIVING_DATE,
POD_AUTO_KEY
FROM QCTL."RC_DETAIL";

BOM:

Load *

where exists(PN_KEY);
SQL SELECT
PNM_AUTO_KEY,
ENTRY_DATE                          AS ITEM_DATE,
NEED_DATE,
ACTIVITY,
SI_NUMBER,
POH_AUTO_KEY||'-'||PNM_AUTO_KEY     AS PN_KEY
FROM QCTL."VIEW_WOBOM"
;