topic Re: Inner Join Do not work in App Development

Inner Join Do not work

Tenuki — Fri, 25 Jul 2025 14:55:50 GMT

I am trying to join two tables, but get an error :

Table_A :

LOAD ProductID, ProductCat, ProductName

FROM [ProductTable.qvd](qvd);

Table_B:

LOAD OrderID, DetailOrderID, ProductID, Amount

FROM [OrderDetail.qvd](qvd);

INNER JOIN

LOAD * FROM Table_A

When I load this, I got "Table_A" not found.

TheLazyDeveloper — Fri, 25 Jul 2025 14:58:54 GMT

Table_A could be auto concatenating if you're using the same fields in another table or you're not doing a resident load of Table_A.

Table_A :

LOAD ProductID, ProductCat, ProductName

FROM [ProductTable.qvd](qvd);

Table_B:

LOAD OrderID, DetailOrderID, ProductID, Amount

FROM [OrderDetail.qvd](qvd);

INNER JOIN(Table_B)

LOAD * RESIDENT Table_A;

anat — Fri, 25 Jul 2025 17:07:45 GMT

why can't you join 2 tables directly without using resident

Table_A :

LOAD ProductID, ProductCat, ProductName FROM [ProductTable.qvd](qvd);

inner join(Table_A )

Table_B:

LOAD OrderID, DetailOrderID, ProductID, Amount FROM [OrderDetail.qvd](qvd);

or if you want to keep Table_A as is and get the common records from Table_B use below logic:

Table_A :

LOAD ProductID, ProductCat, ProductName FROM [ProductTable.qvd](qvd);

noconcatenate

Table_B:

LOAD OrderID, DetailOrderID, ProductID, Amount FROM [OrderDetail.qvd](qvd);

INNER JOIN(Table_B)

LOAD * RESIDENT Table_A;

Tenuki — Mon, 28 Jul 2025 06:32:42 GMT

Hello, many thanks, I didn't have the right synthax.

Tenuki — Mon, 28 Jul 2025 06:33:49 GMT

Thanks, I have managed to do it.