Can someone extend this query?

Hello,
I want to extend this query:
SELECT
M.MID,
M.MAVID,
A.AVOntslagReden
FROM
Medewerker M INNER JOIN AANVRAGEN A ON M.MAVID = A.AVID
WHERE
MAVID = 110
to something like
SELECT
M.MID,
M.MAVID,
A.AVOntslagReden,
1 or 0 indicating that there are (no) records in table U where
U.MeldingID=M.MID <===
FROM
Medewerker M INNER JOIN AANVRAGEN A ON M.MAVID = A.AVID
WHERE
MAVID = 110
Can anyone help me please?
I've been messing with outer joins, group by, and exists but I can't get it
to work ;-(
Thanks very much in advance
jan Doggen--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.|||Hi Jan,
How about ..
SELECT
M.MID,
M.MAVID,
A.AVOntslagReden,
CASE WHEN EXISTS(SELECT 1 FROM U WHERE U.MeldingID=M.ID) 1 ELSE 0 END
FROM
Medewerker M INNER JOIN AANVRAGEN A ON M.MAVID = A.AVID
WHERE
MAVID = 110
-- Alex Papadimoulis
"Jan Doggen" wrote:

> Hello,
> I want to extend this query:
> SELECT
> M.MID,
> M.MAVID,
> A.AVOntslagReden
> FROM
> Medewerker M INNER JOIN AANVRAGEN A ON M.MAVID = A.AVID
> WHERE
> MAVID = 110
> to something like
> SELECT
> M.MID,
> M.MAVID,
> A.AVOntslagReden,
> 1 or 0 indicating that there are (no) records in table U where
> U.MeldingID=M.MID <===
> FROM
> Medewerker M INNER JOIN AANVRAGEN A ON M.MAVID = A.AVID
> WHERE
> MAVID = 110
> Can anyone help me please?
> I've been messing with outer joins, group by, and exists but I can't get i
t
> to work ;-(
> Thanks very much in advance
> jan Doggen
>
>