This question has been answered
Question

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

Answered by Expert Tutors
The student who asked this found it Helpful
Overall rating 100%

"Excellent"

I need the screenshot of query that will return 3 fields from Table 1 (T1) and Table 2 (T2):ID1 , T1.Description1, T2.Description2 For all records...
Get unstuck

261,329 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses