Say i have Four tables
1) Studnets:
- Student_ID
- First Name
- Last Name
2) Contact (Will take the latest item)
- Contact_ID
- Address
- ZipCode
- DateAdded
3) Phone (Will take the last three items)
- Contact_ID
- PhoneNumber
- DateAdded
4) StudentContactRef
- Student_ID
- Contact_ID
How can I query this table? I want to have the fields as shows below:
- Student_ID
- First Name
- Last Name
- Address
- ZipCode
- PhoneNumber1
- PhoneNumber2
- PhoneNumber3