Hello,
I have 2 tables, software and waretype.
The waretype table is a simple table with 2 fields wareid and warename
So the table looks like this
wareid warename
1 shareware
2 trialware
3 donationware
etc etc
The wareid field in above is unique.
The other table software simply contains details about software shock horror
but most importantly in this table I have one field call wareid which
represents the waretype of the app.
I can list the software table to my hearts content and see all the 1 and 2
and 3's that I want but what I really want to see is the waretype name. So
if in the software table the wareid is 1 then going by above example I would
like to see the name shareware, at the minute all I see is 1.
I am new to this and know that it has something to do with 'joins' but I
find it all a tad confusing.
Thanks,
td.
