in
Questions and answers to issues related to Software: Business, Database, Firewalls, Office, Graphics, Security, System, Server. » Database » Sybase » Inner/Outer join ?

Inner/Outer join ?

What's the sybase SQL for the following:

joining data from Table A with Table B where A.ID = B.ID and including data from Table A if no match can be found in Table B

e.g. So the output might be

A.ID  B.ID  A.data  B.data
1       1       green   leaf
2                plant
3                tree
4       4       red        apple

Thanks,
Tim

Solution: Inner/Outer join ?

This would be:

select a.id, b.id, a.data, b.data
from   tablea a, tableb b
where a.id *= b.id

Popular Tags

Browse All Tags