I need to create a query that displ

[zgx]

I need to create a query that displays all rows in the master table (Table.M). A secondary table (Table.S) contains additional values that must be appended if there is a match.

For example:

Table.M columns

PK, columns....

1, joe,33,44,
2, mary,12,89
3, mike,22,9


Table.S columns

1, JJ
3, KK
4, LL

Output


1, joe,33,44, JJ
2, mary,12,89, (null - OK. no value in Table.S)
3, mike,22,9,KK

For some reason, I only display rows where both keys match.

Thank in advance!

JP

 

[jimbopalmer]

In Oracle

Select M.Pk, M.cola, M.colb, M.colc, S.cola from M, S where M.pk = S.pk (+)

the (+) signifys an outer join, where it is permissible for S.Pk to be null I tried to remain child-like, all I acheived was childish.

 

[r937]

oracle, schmoracle, this is the ansi sql forum B-)

select stuff
  from M
left outer
  join S
    on M.pk = S.pk

rudy