System Administration R12 Vol II
System Administration R12 Vol I
I did with union all after changing some logic.
problem solved. Thanks. how can I make this post "Answered".
I also wanted to confirm about my logic means there is no any solution to write this condition in general query, have to change the logic...
I built this query to find the GRN either their invoices have been made or not therefore I used outer join from rcv_transactions rcv table,...