How would I structure it so that it does not pose a SQL Injection risk?

The system is housed on an internal network with no external access, so security is not on the forefront of the clients requirements.

My sincere apologies, through wanting this done quickly I overlooked the fact that the AddressLink table is actually named Address_Link, when I changed it it worked fine as per your...

Sorry about the code,

I had various error messages, ones saying I needed a semi-colon (when I placed the code after the WHERE clause) others just saying SQL Error on-screen (I...

I appreciate that using * is overkill and uses up resources, but for testing purposes I just added it, the actual code will specify 7 Columns, 5 from the Company...

I see where you are coming from, Here is my code so far to get the first part of the postcode and return the addresses of those that match (Thanks...

Once again thanks for the help.

I have another issue,

I can get back the first line of address and postcode just fine as they are both held in the Address Table....

Awesome, thank you all.

The Query returned the correct results and the Join enabled me to put it all together

Thank you once again.

It is pulling the correct data from the first SELECT statement now, Thankyou both, but I have another question.

How do I use the Results of the First Query in the...