I have two table that table 1 contains Number, code, ID and table 2 contains Name, Family name, Number, ID, code, Phone number,...
Now I want to make a query that contains table 2 fields but the query should check that if for example table2 contains table1.Number, show the table 2 fields that contains Table1.Number and if table2 doesn't contains the Table1.Number, show the table 2 fields but just fill the fields that table1 and table 2 have them and just for example put "-" in the filed Phone number because table1 doesn't has that but it has code field and table 2 has it too so it should be fill it with the table 1 parameter And this proccess should be continue for all of the codes of table 1
Table1 has this data
Table 2 data
Can someone help me with this please?