Select result with column from rows in another table.

Hi to all

I have this two table :

TABLE A :
|column_a | column_b|

row_a  |               |               |
row_b  |               |               |

TABLE B


           |column_c | column_d|

row_a  |               |               |
row_b  |               |               |

I don't know if is possible to get a results (with no plsql procedure, but only with a select statement (for example)) like this :

|column_c | column_d|row_a|row_b|

row_a  |               |               |         |        |
row_b  |               |               |         |        |

Thanks a lot Received on Wed Apr 12 2006 - 07:36:08 CDT