Sample Header Ad - 728x90

Make custom query from two table access

0 votes
2 answers
51 views
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 For example: Table1 has this data Table1 Table 2 data Table2 Query example: Result Can someone help me with this please?
Asked by Seena Fallah (113 rep)
Aug 18, 2016, 07:18 PM
Last activity: Nov 29, 2016, 06:29 PM