Problem with report based on query

[meeble]

I have a report based on an SQL query. It doesn't give the results I want.

Here's the query.

SELECT ContactID, Name, Salutation, Title, Company, [Address Line 1], [Address Line 2], [Address Line 3], [Address Line 4], [Postal Code] from Person where Person.ContactID=Order.InvoiceContactID


What's wrong with this?

Cheers

James

 

[formerTexan]

1. What results do you want?
2. What results are you getting?
3. Where is 'Order.InvoiceContactID' coming from?

Cheers,
Bill

 

[meeble]

I think I just need to do a join. In plain English I just want to select all those things from Person where the entries are the same in the ContactID column in Person and the InvoiceContactID column in Order