MPardo
Jun 22nd, 2000, 04:04 AM
Hi,
I need a SQL statement that does an outer join. I know how to do it in Access/SQL Server but need to do it in Oracle as well.
I want to return all the records from one table that match some criteria and any records from another table. The only join I know how to do in Oracle is an "inner" join but this of course doesn't give me all the data I need. Thanks for any help and let me know if more information is required.
Matt
I need a SQL statement that does an outer join. I know how to do it in Access/SQL Server but need to do it in Oracle as well.
I want to return all the records from one table that match some criteria and any records from another table. The only join I know how to do in Oracle is an "inner" join but this of course doesn't give me all the data I need. Thanks for any help and let me know if more information is required.
Matt