I need the screenshot of query that will return 3 fields from Table 1 (T1) and Table 2 (T2):

T1.ID1 , T1.Description1, T2.Description2

For all records that have value in field ID1 in Table 1 equal value in field ID2 from table 2 AND corresponding Description fields

are not the same. Order the list by ID1.

( as I wrote ealier T1.ID1=T2.ID2 AND T1.Description1<>T2.Description2

Order by T1.ID1)

FYI:

All data is VARCHAR2

Tables are at different Servers and Schemas

Table 1

ID1 Description1

01 White

02 Red

Table 2

ID2 Description

01 White

02 Blue

Desired result:

ID1. Description1. Description2

02. Red Blue