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
Default

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 ?

Mateen



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