skip to main | skip to sidebar

Sanjeewa'S Tech Page

Friday, September 28, 2007

Sql Query Which give ID not in another table

SELECT PL.id from PL
WHERE PL.Id
not in(select PS.ListNo from PS)
Posted by SS - LK at 10:43 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2010 (9)
    • ►  October (1)
    • ►  May (2)
    • ►  April (3)
    • ►  February (2)
    • ►  January (1)
  • ►  2009 (29)
    • ►  December (2)
    • ►  October (2)
    • ►  August (3)
    • ►  July (3)
    • ►  June (3)
    • ►  May (3)
    • ►  April (5)
    • ►  January (8)
  • ►  2008 (46)
    • ►  November (1)
    • ►  October (14)
    • ►  August (11)
    • ►  May (7)
    • ►  April (1)
    • ►  March (2)
    • ►  February (10)
  • ▼  2007 (33)
    • ►  December (1)
    • ►  November (7)
    • ►  October (11)
    • ▼  September (12)
      • using a populated dataset (one row of data) displa...
      • Bind dorop down to dataset object easyly
      • Example of How to join 3 tables using inner join
      • Sql Query Which give ID not in another table
      • Get curent date and time formatted and display usi...
      • Format date fome the database (not front end)
      • Assign default value to a object is when assign de...
      • Implement mail functionality link using a hypelink
      • Getting Values from asp.net data grid view
      • Send the mail using Threading
      • Handling row edit Event in dataGrid
      • Format DataGrid data format without time
    • ►  July (2)
 

You like my blog?

Search This Blog

Followers