Results 1 to 3 of 3

Thread: Query help list

  1. 02-07-2007, 10:59 PM #1
    Steven Low
    Steven Low is offline VB.NET Forum Enthusiast
    .NET Framework
    .NET 1.1 (VS 2003)
    Join Date
    Apr 2005
    Posts
    42
    Reputation
    101

    Query help list

    Resolved
    Resolved
    Resolved
    Last edited by Steven Low; 04-05-2007 at 1:52 PM. Reason: Resolved
    Reply With Quote Reply With Quote
  2. 02-08-2007, 7:13 AM #2
    cjard's Avatar
    cjard
    cjard is offline VB.NET Forum All-Mighty
    .NET Framework
    .NET 4.0
    Join Date
    Apr 2006
    Posts
    7,027
    Reputation
    1705
    Code:
    SELECT 
  dept.*
FROM
  dept
  LEFT OUTER JOIN
  emp
  ON
    emp.deptNo = dept.deptNo
WHERE
  emp.deptno IS NULL
ORDER BY 
  dept.deptno
    DW1 DW2 DW3 DW4 DNU PQ
    Reply With Quote Reply With Quote
  3. 02-08-2007, 11:31 AM #3
    Steven Low
    Steven Low is offline VB.NET Forum Enthusiast
    .NET Framework
    .NET 1.1 (VS 2003)
    Join Date
    Apr 2005
    Posts
    42
    Reputation
    101

    Resolved

    Hi cjard

    Thanks for that. Got it working thanks to you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules

Harvest time tracking