join problem

rbuser

Hi

is a query like this possible with the end user tool:

SELECT
PERSONEN.Persoons_ID
PERSONEN.Naam ,
VASTE_LOONCOMPONENTEN_PER_SALARISKAART.Bedrag
FROM
PERSONEN PERSONEN
LEFT OUTER JOIN VASTE_LOONCOMPONENTEN_PER_SALARISKAART
VASTE_LOONCOMPONENTEN_PER_SALARISKAART
ON (PERSONEN.BCS_Nummer =
VASTE_LOONCOMPONENTEN_PER_SALARISKAART.BCS_Nummer)
AND (PERSONEN.Persoons_ID =
VASTE_LOONCOMPONENTEN_PER_SALARISKAART.Persoons_ID)
AND (VASTE_LOONCOMPONENTEN_PER_SALARISKAART.Vast_looncomponent = 32 )

Especialy the last line !!

Eric

nicocizik

Hi Eric,

The ReportBuilder data workspace does not allow you to join on a specific
value. One option would be to use the where clause to search on that
condition. Another would be to create the query manually.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com