nicht angemeldet
Hi Denise!
SELECT Tab1.WOHNEINHEIT
FROM Tab1
INNER JOIN Tab2 ON (Tab1.WOHNEINHEIT = Tab2.WOHNEINHEIT) AND (SUM(Tab2 .PERSONEN) > 14)
Ungetestet. Ich hoffe, es funktioniert. Aber die Datenbankprofis werden schon einschreiten, wenn es nicht stimmt. =)
MfG H☼psel
--
"It's amazing I won. I was running against peace, prosperity, and incumbency."
George W. Bush speaking to Swedish Prime Minister unaware a live television camera was still rolling, June 14, 2001
Selfcode: ie:% fl:( br:> va:) ls:& fo:) rl:? n4:& ss:| de:] js:| ch:? sh:( mo:) zu:)
"It's amazing I won. I was running against peace, prosperity, and incumbency."
George W. Bush speaking to Swedish Prime Minister unaware a live television camera was still rolling, June 14, 2001
Selfcode: ie:% fl:( br:> va:) ls:& fo:) rl:? n4:& ss:| de:] js:| ch:? sh:( mo:) zu:)