Query - Select two tables where a.id=b.id

Query - Select two tables where a.id=b.id

am 28.12.2007 08:05:35 von info

Hi,

my query is:

SELECT a.symbol_art,b.node_key

FROM artykuly a, art_podz b

WHERE a.symbol_art=b.symbol_art

------------- -------------------

table: artykuly table art_pod

a.symbol_art b.symbol_art

AA-0001 AA-0001 = record ok

AA-0002 NULL = >>>>>>>>> I want to view diference
records symbol_art in two tables

How select all a.symbol_art where in table art_podz b.symbol_art is no exists?

tnx.

Tom

Re: Query - Select two tables where a.id=b.id

am 28.12.2007 09:33:40 von Erland Sommarskog

info (informatyk@fitness[CUT]authority.pl) writes:
> my query is:
>
> SELECT a.symbol_art,b.node_key
>
> FROM artykuly a, art_podz b
>
> WHERE a.symbol_art=b.symbol_art
>
> ------------- -------------------
>
> table: artykuly table art_pod
>
> a.symbol_art b.symbol_art
>
> AA-0001 AA-0001 = record ok
>
> AA-0002 NULL = >>>>>>>>> I want to view diference
> records symbol_art in two tables
>
> How select all a.symbol_art where in table art_podz b.symbol_art is no
> exists?

You need to use an outer join:

SELECT a.symbol_art,b.node_key
FROM artykuly a
LEFT JOIN art_podz b ON a.symbol_art=b.symbol_art

With an outer join all rows in the table on the outer side, left here,
are maintained in the result set.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Query - Select two tables where a.id=b.id

am 09.01.2008 21:11:00 von Knowledgy

Research information on joins. This includes inner joins, left outer join,
right outer join, full outer join and cross joins

--
Sincerely,
John K
Knowledgy Consulting, LLC
knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts


"info" wrote in message
news:fl2785$f5k$1@news2.task.gda.pl...
> Hi,
>
> my query is:
>
> SELECT a.symbol_art,b.node_key
>
> FROM artykuly a, art_podz b
>
> WHERE a.symbol_art=b.symbol_art
>
> ------------- -------------------
>
> table: artykuly table art_pod
>
> a.symbol_art b.symbol_art
>
> AA-0001 AA-0001 = record ok
>
> AA-0002 NULL = >>>>>>>>> I want to view
> diference records symbol_art in two tables
>
> How select all a.symbol_art where in table art_podz b.symbol_art is no
> exists?
>
> tnx.
>
> Tom
>
>
>
>
>
>
>
>