Inner Join Do not work

[LF_PECO]

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 · Accepted solution]

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]

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;

[LF_PECO]

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

[LF_PECO]

Thanks, I have managed to do it.