Search results

  1. S

    Deleting records from one table based on another table

    Hi folks, I have 2 tables - Companies and Executives. I have CompID as PK in Companies and FK in Executives. I have ExecID as PK in Executives. I want to delete all the companies that do not have an executive in them. Please advise how do I write the query to achieve this. Thanks, Sudhir.
View older results
Back
Top Bottom