Basic subquery, not working (example provided)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to run following query:

SELECT DBA_t_order.t_order_faktnr, DBA_t_order.t_order_ordernr INTO _table1
FROM DBA_t_order
WHERE (((DBA_t_order.t_order_faktnr) In (SELECT DISTINCT
dbo_SL03L000.SL03002 FROM dbo_SL03L000 WHERE (dbo_SL03L000.SL03042)="1")));

But nothing happens (I have a relation between DBA_t_order and dbo_SL03L000
in "relationmanager").

Am I missing something obvious here?

Kindly,
Mikael
 
What is the datatype of dbo_SL03L000.SL03042? If it is a number then remove
the quotes from the '1' WHERE (dbo_SL03L000.SL03042)="1")));
to read WHERE (dbo_SL03L000.SL03042)=1)));
 
Back
Top