Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 44,615 points

Alex

Favorite Answers18%
Answers955

Software reviewer at http://www.filesland.com On a daily basis I see dozens of software applications with different functions.

...More

  • MS SQL SERVER 2000 query. Help!?

    What is wrong with this query?

    DELETE tbCompanies.* FROM tbCompanies

    WHERE [ID] not IN

    (Select Distinct [CompanyID] as [ID] from [tbProducts] )

    order by [Name]

    there are two tables: tbCompanies and tbProducts, tbCompanies. [ID] is a foreign key to tbProducts.[CompanyID]

    I want to delete records for all companies that do not have any listed products, the error is Line 1: Incorrect syntax near '*'.

    2 AnswersProgramming & Design1 decade ago