Hi guys,

I need help with a querry. (Access DB 2003)

I have 2 Tables

Table1.....Field
===========
..............GuestID
..............GuestName

The Field GuestID is Unique and starts either with the letter 'F' or 'P' depending if the guest is a private person or a company


Table2.....Field
===========
.............BookingID
.............GuestID1
.............GuestID2
.............Arrival
.............Departure

The Fields GuestID1 and GuestID2 are the link to the Table1.GuestID
GuestID1 has alltimes a value GuestID2 could have an entry. This is
depending if on the Invoice has the private and company name on it.


So what I need is a querry which solves the following
Result should look like this

Table2.BookingID
Table1.GuestName - Related to Table2.GuestID1
Table1.GuestName - Related to Table2.GuestID2 (keep in mind this
...................................................................field could be NULL)

the rest I think i can figure out . hopefully

Hope you can help me with this.

many thx in advance and a peacefull xmas season to you all.