Can anyone figure out this MySQL query?

Hi;

Below are two tables which I need to query information from. Problem is I cannot figure out the correct SQL statement to get the information. Unfortunately I cannot change the design of the tables due to historic reasons. Anyway, first the tables:

Customers

+-------------------------+

 +-------------------------|


|1          | Bob         |

|2          | George      |


|3          | Fred        |


+-------------------------+

Invoices

+--------------------------------+

 +--------------------------------+


|1         | 1       | 1         |

|2         | 1       | 2         |

|3         | 2       | 1         |

|4         | 2       | 2         |

|5         | 3       | 3         |


|6         | 3       | 1         |


+--------------------------------+

Now, on to my query: I'd like to SELECT the all records FROM Invoices WHERE for example CustomerNo 1 AND CustomerNo 2 stayed at the same hotels. In this case it should match InvoiceNo 1,2,3,4 BUT NOT 5,6 Obviously I'd like to query by CustomerName so I'd like to use an inner join for that, but that part is OK. Any ideas?

Many Thanks
  Chris Received on Wed Aug 30 2000 - 10:40:57 CEST