Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    14

    Unanswered: Help with making query

    Learnt MySQL and used the Count function. Thanks for your advice though.
    Last edited by Viking-ex; 04-22-04 at 08:41.

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Cool hello

    watch you syntax

    id = 1
    CountRentals: Count(RentalTBL.RentalID=FilmTBL.FilmID = [?])

    or

    Name like "Matrix, The"
    CountRentals: Count(RentalTBL.RentalID=FilmTBL.FilmName LIKE [?])

  3. #3
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Cool better

    SELECT Count(FilmName ) as CountRentals
    From FilmTBL
    LEFT JOIN RentalTBL ON FilmTBL.FilmID =RentalTBL.FilmID
    Where FilmName LIKE [?]

Posting Permissions

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