View Single Post
Old October 7th, 2003, 04:26 AM
mateenmohd mateenmohd is offline
Friend of Wrox
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts

thanks for response.

by mapping it display only one record.
I have to display number of records ie softwares and their version
one comp1 have many softwares and each software separate version.

any other idea ?


quote:Originally posted by Deepesh_Jain

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