How to use where clause in the oracle join?
Hi Everyone,
I have the below query the inner join with the where clause. Though, the query gets executed but does not return any value. How to use where clause in the Oracle Inner Join?
I have the below query the inner join with the where clause. Though, the query gets executed but does not return any value. How to use where clause in the Oracle Inner Join?
Select U.a from U Inner Join E on
E.entity = U.entity Where U.Unique_name = 'AREA ID';SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Guy Hengel, Thanks for explaining me in detail. But I need to have the e table in the query and I tried the left outer join then it does not use any filter and gives me back 1000 rows.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@magarity, The result should '1234',
2345,
3456,
4567. Numbers like this...
2345,
3456,
4567. Numbers like this...
What we would be looking for is raw data from the two tables and expected results so we can set up a test case and provide working code.
ASKER