I have three different tables within a database and need to return data based on a query from each table, is this possible?
The tables are named as follows:
table1 = housingasbcase
table2 = cccontact
table3 = CCADDRESS
table4 = gazuprncoords
The data I need to retreieve is as follows

housingasbcase & cccontact
Both of these 2 tables have a column named ContactNumber. I need to retrieve all data from cccontact column "UPRN"
where ContactNumber is present in both tables. 
CCADDRESS
Using UPRN results returned from above query I need to search CCADDRESS and return all data from a column called "REALUPRN", where column "UPRN" matches (UPRN column is present in CCADDRESS and CCContact) 
gazuprncoords
Finally with the results from above continaing "REALUPRN" I need to search a table gazuprncoords and return fields "XCOORD" & "YCOORD" where there is a match on column REALUPRN
Example of table data to better explain:
> 1.housingasbcase
> 
> ContactNumber
> 
> 234432 
> 563454 
> 345345 
> 345353 
> 
> 2.cccontact
> 
> ContactNumberUPRN 
> 
> 234432 001 
> 563454 002 
>   
>   
> 
> 3.CCADDRESS
> 
> UPRN RealUPRN 
> 
> 001 123456 
> 
> 4.GAZUPRNCOORDS
> 
> REALUPRN XCOORD YCOORD
>  
> 123456 0006 0008 
>    
> 
EDIT: Sorry guys the formatting of the post keeps throwing my table illustration out, I hope you can see what I mean.
How would I go about doing this, do I need to use a number of different joins somehow?