Code: Select all
select i.CustomerID, i.CompanyName, i.City, i.Country, k.OrderDate, k.OrderID, p.ProductID from Customers i, Orders k,'Order Details' p where i.Country in ( 'Germany', 'France', 'Spain');
as a result it takes several seconds with no result coming back but instead a box pops up, saying "out of memory". The program seem defunct from then on.
The query itself may appear to be not so senseful, but I'm using a complex query to find a bug example in another program.
--
Christoph