Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Red face Unanswered: reservation query help...

    hi guys,

    i am trying to query database to find out if a apartments of a particular building is book or not.

    table are somthing like

    tblbuilding
    ========

    idbuilding
    title
    numberofApartments

    tblbooking
    ========

    idbooking
    apartmentNumber
    idbuilding
    dateto
    datefrom


    ============
    so i want to check how many units are available on particular date or period.


    any help would be appropriated.

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    What have you tried so far?

  3. #3
    Join Date
    Jun 2008
    Posts
    2
    thanks for interest able to find a way...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •