From: Volkan YAZICI (yazicivo@itu.edu.tr)
Date: Thu 22 Apr 2004 - 22:20:26 EEST
merhaba,
postgresql@irc.freenode.net'teki oicu adli amcamin yardimlari ile JOIN
ve WHERE ifadeleri kullanmadan guzel bir farkli satir yakalayici:
SELECT * FROM (
(SELECT 'mytable' AS _table_name_, * FROM mytable
EXCEPT
SELECT 'mytable' AS _table_name_, * FROM mytable2)
UNION
(SELECT 'mytable2' AS _table_name_,* FROM mytable2
EXCEPT
SELECT 'mytable2' AS _table_name_,* FROM mytable)
) AS dummy;
iyi calismalar
On Thu, 22 Apr 2004 16:34:45 +0300
temiz <temiz@deprem.gov.tr> wrote:
> merhaba
> iki sql tablosu var. Bunlar buyuk cogunlukla ayni
> satirlara sahip ancak ikincide az da olsa farkli satirlar var
> bu farkli satirlari nasil elde edebilirim ?
>
> saygilar
>
> onceki yardim icin Gurkan ve Volkan beye ayrica tesekkurler
>
> Ahmet Temiz
>
>
> ______________________________________
> Inflex - installed on mailserver for domain @deprem.gov.tr
> Queries to: postmaster@deprem.gov.tr
>
> ______________________________________
> The views and opinions expressed in this e-mail message are the
> sender's own and do not necessarily represent the views and the
> opinions of Earthquake Research Dept. of General Directorate of
> Disaster Affairs.
>
> Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal
> olarak T.C. B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni
> baglayici nitelikte degildir.
>
> ---
> linux-baslangic listesinden cikmak ve tum listeci islemleri icin
> http://liste.linux.org.tr/ adresini kullanabilirisniz.
> Bu listeden cikmak icin
> <a
> href="mailto:linux-baslangic-request@liste.linux.org.tr?Subject=unsub
> scribe"> tiklayiniz</a>
-- Attached file included as plaintext by Ecartis --
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAiBsLGcWq5WdHoacRAkjYAKCoZK9X3H5CwvrFRrXww13DEELfIwCbBKy8
Iawr0eQ/DECuQcFElMl8qTM=
=DxY9
-----END PGP SIGNATURE-----
---
linux-baslangic listesinden cikmak ve tum listeci islemleri icin
http://liste.linux.org.tr/ adresini kullanabilirisniz.
Bu listeden cikmak icin
<a href="mailto:linux-baslangic-request@liste.linux.org.tr?Subject=unsubscribe"> tiklayiniz</a>