Database not found error There is no open data connection.

[Nynaeve88]

Hi,

I'm trying to left join two tables of unequal length. However, I get the following two errors: 

(1) Database not found error  There is no open data connection. QVTable:
SELECT * FROM OGE

(2) Database not found error 
There is no open data connection.
Left Join Select * FROM KNMI_20110708

Based on the other discussion with this topic I tried copying my code to a new file but this didn't solve the issue. 

When I remove the join code the script is working again. 

I'm using the below script

Please help?:)

LOAD 
[Exploitatie ingangsdatum],
[OGE Bouwjaar],
[OGE Energie Label Empire (Empire)],
Year([Exploitatie ingangsdatum]) as Exploitatiejaar
FROM
[D:\X\BM-case\OGE.xlsx]
(ooxml, embedded labels);

LOAD YYYYMMDD as [Exploitatie ingangsdatum],
FHVEC as Windsnelheid,
TG as [Temp gem],
TN as [Temp min],
TX as [Temp max],
RH as [Regen]

FROM
[D:\X\KNMI_20110708.txt]
(txt, utf8, embedded labels, delimiter is '\t', msq);

QVTable:
SELECT * FROM OGE;

Right Join Select * FROM KNMI_20110708;

[Nynaeve88]

Obviously I'm using Left Join instead of Right join. I tried using the other function to see if that might work and copied that code.. No luck there though.

[jerrysvensson]

QVTable:
SELECT * FROM OGE;

left Join (QVTable)

SQL Select * FROM KNMI_20110708;

Should work.

[Nynaeve88 · Accepted solution]

I still get this error:

Database not found error

There is no open data connection.

QVTable:
SELECT * FROM OGE

The problem really lies with connecting to the data tables via the select function I think.

Trying to solve another issue  I found the following solution that uses the left join function without using select :

LEFT JOIN(PRELOAD1)
LOAD * RESIDENT PRELOAD2;

DROP TABLE PRELOAD2;