Re: Join "with no matches on other table"

2003-06-11 Thread Martin Waite
On Wed, 2003-06-11 at 13:48, Ville Mattila wrote: > Hello, > > I have two tables, other having information of cottages and other including > information when each cottage is booked. The table structures are following: > > Cottages: > - code > - name > - equipment > > Reservations: > - cottagecod

Join "with no matches on other table"

2003-06-11 Thread Ville Mattila
Hello, I have two tables, other having information of cottages and other including information when each cottage is booked. The table structures are following: Cottages: - code - name - equipment Reservations: - cottagecode - begindate - enddate I'm looking for a query structure that I can use