2 Tabellen verknüpfen

[Robert_G]

klaro, sollte selbsterklärend sein...

SQL-Code:

create Table A
(
  Id    Integer not null,
  Name  VarChar(55) not null
)

SQL-Code:

create Table B
(
  PK          Integer not null,
  Miep        VarChar(55) not null,
  Description VarChar(2000)
)

SQL-Code:

SELECT Id
      ,Name
      ,null  as Description 
FROM   A
UNION ALL
SELECT Pk    as Id
      ,Miep  as Name
      ,Description 
FROM   B