Thomas Ehret@CHEDSZURICH
06.03.2000 19:16
In BO, how can I reference in the where clause of a subquery to the select-clause of the master query ?
SELECT A.ARTNR,A.DATUM,A.VALUE FROM TABLE A WHERE A.DATUM = (SELECT MAX(B.DATUM) FROM TABLE B WHERE A.ARTNR = B.ARTNR)
Listserv Archives (BOB member since 2002-06-25)
Thomas, i think you can write the whole statement as it is in the Select space of object definition ,it works …
Listserv Archives (BOB member since 2002-06-25)
In a message dated 00-03-06 13:34:50 EST, you write:
In BO, how can I reference in the where clause of a subquery to the select-clause of the master query ?
SELECT A.ARTNR,A.DATUM,A.VALUE FROM TABLE A WHERE A.DATUM = (SELECT MAX(B.DATUM) FROM TABLE B WHERE A.ARTNR = B.ARTNR)
What you are looking for is a Correlated Sub-query. You can do this in BusObj if you use the Calculation wizard. To invoke this on the query panel, start your condition as you normally would. Drag the object referencing A.DATUM on to the Conditions are of the query panel, select Equal To as your operator, and then select Calculation (it should be at the bottom of the list) as your operand. The wizard will walk you through a number of steps.
If you know what you are trying to accomplish, the steps should make sense.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)