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

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,,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