View Single Post
 
Old October 7th, 2003, 04:05 AM
Deepesh_Jain Deepesh_Jain is offline
Authorized User
 
Join Date: May 2003
Location: Delhi, Delhi, India.
Posts: 62
Thanks: 0
Thanked 0 Times in 0 Posts
Default



Try to do the mapping between all the three table using rec_id like this:
select stations.rec_id,stations.stn_no,
softwarelist.rec_id,software.software,softwarelist .version
from stations,software,softwarelist
 where stations.rec_id=software.rec_id
and stations.rec_id=softwarelist.rec_id


Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team