Results 1 to 2 of 2

Thread: inner joins and where

  1. #1
    Join Date
    Dec 2011
    Posts
    2

    inner joins and where

    Hi all

    I have been trying to do this for days and so decided to ask for some advice.

    We have 4 tables and want to write a query for php that essentially checks
    1) id from one table (a/) is in another(b) AND 2) id from one table (c) is not in (d)
    3) the date from b is before now()

    I get that I need to do an inner join on all 4 tables but not sure about the where and especially how to write the not part. I thought would be
    user.userID=!cart.userID but it doesnt work


    Please help

    Thanks

    Nicole

  2. #2
    Join Date
    Dec 2011
    Posts
    2
    sorry number 1) should read
    1) id from one table (a/) is in another(d)

    Nicole

Posting Permissions

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