Hi,
I'm relatively new to Access and I'm trying to write a query here. i have 3 tables:
Table 1
Code:
P_id
Name
email
S_id
1
Abc
abc@abc
a
2
Def
def@def
b
3
Ghi
ghi@ghi
c
Table 2
Code:
P_id
Company
Address
1
Abc company
Abc’s address
2
Def company
Def’s address
3
Ghi company
Ghi’s address
Table 3
Code:
S_id
Country
Ph. No.
a
USA
12345
a
Spain
11111
a
India
98945
b
India
67890
b
Spain
22222
b
USA
77777
c
USA
75757
Output:
Code:
Name
email
Company
Address
India
Abc
abc@abc
Abc company
Abc’s address
98945
Def
def@def
Def company
Def’s address
67890
Ghi
ghi@ghi
Ghi company
Ghi’s address
So, I need details of Ghi user also even if it does not have India phone number and have India as a column header. Is that possible? Can someone tell me how the query will look like?
Thanks! Do let me know if you need any information.