How to make a join within the same table?

there is a table:
-- auto-generated definition
create table nativeids
(
 nativeId varchar(32) not null
 primary key,
 offerId varchar(32) not null
)
 engine = InnoDB
 collate = utf8mb4_unicode_ci;

create index nativeids_offerid_index
 on nativeids (offerId);

there are two input values $nativeId='abc3' $offerId='abc2'
you need to make one request which returns the following possible values
(5 options)
nativeId | offerId

 null | nulll

 null | abc2

 abc1 | null

 abc1 | abc2

 null | abc2
-----------------
 abc1 | null


Understand that you need to do a join but got confused as.
June 3rd 19 at 19:28
1 answer
June 3rd 19 at 19:30
there is another - Tyrese.Hoeger commented on June 3rd 19 at 19:33
, there is exactly what You need - JOIN the table to itself.
and how to display it - there is a condition set for a particular situation - skye.Satterfield72 commented on June 3rd 19 at 19:36
before you answer the question you need to read and comprehend it to the end - Tyrese.Hoeger commented on June 3rd 19 at 19:39
agree.
Question: how to make a JOIN table to itself
The link is exactly the answer.

Or do You propose the request to write? - skye.Satterfield72 commented on June 3rd 19 at 19:42
,
Question: how to make a JOIN table to itself
is only the header, and then written in the question details. Namely, what question should answer the request. but the sql syntax I can see in the documentation. By the way, the problem is already solved and there need 2 join in the same table. - Tyrese.Hoeger commented on June 3rd 19 at 19:45

Find more questions by tags MySQL