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.
Question
SQL subquery
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 select all the fields from icdist where icdist.tranno=ictran.ttran
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- Participating Experts
- 2
- Solution Grade
- A
Posted on 2009-10-22 at 09:05:34ID: 26270586
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.