SELECT ma.name,
f.name,
mo.name,
p.man,
p.fam,
dd.price,
no.price2
FROM notebook no,
proctype p,
model mo,
family f,
manufacturer ma,
domain_details dd
WHERE no.id ='1465' and
no.procid = p.id and
no.modid = mo.id and
mo.famid = f.id and
f.manid = ma.id and
dd.idnotebook = no.id and
dd.domain = 1| | IBM ThinkPad T43 | 
| On Sale Now! $443
Current Price: $588
| CPU | Intel Pentium M 1860 | | HDD | 40 GB | | Memory | 1024 MB | | CD-ROM | CDRW/DVD | | FDD | | | Display | 14.1 TFT | | Display adapter | ATI Mobility RADEON x300 | | Battery | Li-Ion, 6 Cell | | Mouse | UltraNav dual-pointing system, featuring TrackPoint and customized touch pad for the ultimate in pointing flexibility is a part of the keyboard | | Sound | AD1981A AC'97 SoundMAX Codec (Full-duplex), Stereo Speakers | | | | | PCMCIA | One Type III slot, can accommodate two Type II or one Type III PC card | | Interfaces | Two USB ports version 2.0, One parallel (EPP, ECP) compatible, Additional connector supports the optional Port Replicator and dock, Two audio ports (One for external stereo speakers or headphone, one for microphone-in), S-Video out, CRT port for external monitor, built-in RJ-11 and RJ-45 connectors for telephony and LAN connections | | | 56K | | Other | Built-in 802.11b/g Wireless |  |
| | | (For quantity orders) |
|
|
