Professional Web Applications Themes

How do i get only one row if all the children meet my clause - MySQL

Please help I have a table with orders in and a different table with tasks in I want to Pull only the orders where all the tasks have been completed Order1 has many children Task 1 , Open Task 2 , Open Task 3 , Completed Order 2 Task 3 closed Task 4 closed I want the query only to pull out order 2 Please help...

  1. #1

    Default How do i get only one row if all the children meet my clause

    Please help
    I have a table with orders in and a different table with tasks in
    I want to Pull only the orders where all the tasks have been completed

    Order1 has many children
    Task 1 , Open
    Task 2 , Open
    Task 3 , Completed

    Order 2
    Task 3 closed
    Task 4 closed

    I want the query only to pull out order 2

    Please help



    Guest

  2. #2

    Default Re: How do i get only one row if all the children meet my clause

    -> SELECT tasks.order_id FROM tasks WHERE tasks.order_id NOT IN(
    -> SELECT o1.order_id
    -> FROM tasks t
    -> LEFT JOIN orders o1
    -> ON o1.order_id = t.order_id
    -> WHERE t.status !='closed');

    or something like that

    g wrote:
    > Please help
    > I have a table with orders in and a different table with tasks in
    > I want to Pull only the orders where all the tasks have been completed
    >
    > Order1 has many children
    > Task 1 , Open
    > Task 2 , Open
    > Task 3 , Completed
    >
    > Order 2
    > Task 3 closed
    > Task 4 closed
    >
    > I want the query only to pull out order 2
    >
    > Please help
    strawberry Guest

Similar Threads

  1. pulling in children of children in XML
    By flipflop9 in forum Macromedia Flash Data Integration
    Replies: 4
    Last Post: September 27th, 10:11 AM
  2. Using IN in a WHERE clause
    By drmaves in forum Coldfusion Database Access
    Replies: 15
    Last Post: September 5th, 05:05 PM
  3. CF MX 6 WHERE Clause
    By Jeremy5431 in forum Macromedia ColdFusion
    Replies: 13
    Last Post: May 2nd, 02:26 PM
  4. if-clause not working
    By M. Görg in forum PHP Development
    Replies: 2
    Last Post: July 14th, 03:46 PM
  5. connect by clause
    By shankar72 in forum Oracle Server
    Replies: 0
    Last Post: July 10th, 08:56 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139