Question

Asked on 2009-10-22 at 10:08:00ID: 25040652

Delete records based on SQL query

by: mbibmdi250

Rating9.1Excellent

Hi Experts,

Have 2 files, icdist and ictran.  icdist has 2 records for every tranno.  ictran has 1 record for every ttranno.  I want to delete all the fields from icdist where icdist.tranno=ictran.ttranno.  Thanks for your help

Related Solutions

Solution

Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution
Sign up Now to View This Solution
Zone
general
Tags
Participating Experts
3
Solution Grade
A

Replies

 by: Allister_Reid

Posted on 2009-10-22 at 10:23:41ID: 26270580

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: mbibmdi

Posted on 2009-10-22 at 10:42:01ID: 26270581

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: mbibmdi

Posted on 2009-10-22 at 10:52:13ID: 26270582

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: pcelba

Posted on 2009-10-22 at 11:36:16ID: 26270583

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: Allister_Reid

Posted on 2009-10-22 at 13:51:47ID: 26270584

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: tusharkanvinde

Posted on 2009-10-22 at 21:35:58ID: 26270585

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Top Experts

  1. pcelba

    4,240

    0 points yesterday

    Profile
  2. mozner

    2,000

    0 points yesterday

    Profile
  3. mbarbir

    1,912

    0 points yesterday

    Profile
  4. jrbbldr

    1,500

    0 points yesterday

    Profile

BrowseAre you an Expert?