<div>
Hi,<br />
<br />
You can use Union <br />
<br />
Select &nbsp;fav_user.id, favuser.name from fav_user<br />
union<br />
Select user.id, user.name from user<br />
<br />

</div>


Hi,

You can use Union

Select  fav_user.id, favuser.name from fav_user
union
Select user.id, user.name from user



<div>
Can you post some sample data and the expected results?
</div>


Can you post some sample data and the expected results?

<div>
<div class="content wysiwyg-content">
Suppose i have table name tblfavuser(Contains data of favorite user) &nbsp; &nbsp;and tbluser(contains the user data). I &nbsp;want to show distinct record from both table and tblfavuser comes first then tbluser.
</div>
</div>


Suppose i have table name tblfavuser(Contains data of favorite user)    and tbluser(contains the user data). I  want to show distinct record from both table and tblfavuser comes first then tbluser.

Select Data From Two Tables And show distinct  records and second  table records come first then  first table record and having relationship.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.