Hi.

Is it possible just with SQL to use the result of one query in another query?

For instance:
SELECT MAX(No) FROM Customers;
SELECT * FROM SALESLINES WHERE CUSTNO={Result from first query};

"John" <eydunl@post.olivant.fo> wrote in message
news:0E5DDB2F-72D5-4905-AF6D-513F36D1ED28@news.elevatesoft.com...
> Hi.
>
> Is it possible just with SQL to use the result of one query in another
> query?
>
> For instance:
> SELECT MAX(No) FROM Customers;
> SELECT * FROM SALESLINES WHERE CUSTNO={Result from first query};
>

select * from salesline where custno in
(select max(no) from customers)

Be careful though, there are speed issues with these type subqueries. A
safer way is using a script

select max(no) maxno into memory\temp from customers;
select * from salesline
join memory\temp on maxno = custno;

Robert

Thanks