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 ='2635' 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| | HP CPQ NC2400 |
| On Sale Now! $346 Current Price: $527
| CPU | Intel Core Solo U1400 1200 | | HDD | 60 GB | | Memory | 1024 MB | | CD-ROM | CDRW/DVD | | FDD | | | Display | 12.1" WXGA | | Display adapter | Intel Graphics Media Accelerator 950, up to 224-MB shared system memory, Max resolution 1280 x 800 | | Battery | Lithium Ion | | Mouse | Pointstick with two pick buttons | | Sound | PremierSound High Definition Audio support w/24-bit DAC | | | | | PCMCIA | 1 Type I/II PC Card slot supports 32-bit CardBus and 16-bit cards or integrated Smart Card Reader | | Interfaces | 2 USB 2.08, VGA, RJ-11, RJ-45, headphone, microphone, IEEE 1394a | | | 56K | | Other | |  |
| | | (For quantity orders) |
|
|