Re: usuwanie rekordów z tabeli

Article View: pl.comp.bazy-danych.msaccess

Article #137054

Back to pl.comp.bazy-danych.msaccess Previous Next

#137054

From: MaciejF
Date: Fri, 27 Nov 2015 16:40

10 lines
1536 bytes

Może tak:

DELETE * FROM URLOPY
WHERE PESEL NOT IN (SELECT DISTINCT PESEL FROM OSOBY)

Pisane z palca.
Pokombinuj z podkwerendami (kwerendami zagnieżdżonymi)
Pomysł na szybko po przeczytaniu twojego ostatniego posta.

MF

Technical Details

Message-ID: <4b076266-7fd4-45cf-8e2a-812287b2e758@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin3!goblin.stu.neva.ru!news.ripco.com!news.glorb.com!mv3no4113526igc.0!news-out.google.com!f6ni14118igq.0!nntp.google.com!mv3no5342747igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

References: <484699c6-2941-416f-8aee-2d7a69d14398@googlegroups.com>

Show Full Headers

Complete Article Headers

X-Received: by 10.182.255.203 with SMTP id as11mr46473358obd.49.1448642409124;        Fri, 27 Nov 2015 08:40:09 -0800 (PST)
X-Received: by 10.50.50.237 with SMTP id f13mr126312igo.9.1448642409063; Fri, 27 Nov 2015 08:40:09 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin3!goblin.stu.neva.ru!news.ripco.com!news.glorb.com!mv3no4113526igc.0!news-out.google.com!f6ni14118igq.0!nntp.google.com!mv3no5342747igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Fri, 27 Nov 2015 08:40:08 -0800 (PST)
In-Reply-To: <484699c6-2941-416f-8aee-2d7a69d14398@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=178.36.125.236; posting-account=kc7ZIQoAAAB5PkdJgxjq1dd8jnBK4MVp
NNTP-Posting-Host: 178.36.125.236
References: <484699c6-2941-416f-8aee-2d7a69d14398@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4b076266-7fd4-45cf-8e2a-812287b2e758@googlegroups.com>
Subject: Re: usuwanie rekordów z tabeli
From: MaciejF <maciejfr@onet.pl>
Injection-Date: Fri, 27 Nov 2015 16:40:09 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message