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 ='2642' 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| | Acer Aspire One AOA150-Blue | 
| On Sale Now! $322
Current Price: $467
| CPU | Intel Atom 1600 | | HDD | 120 GB | | Memory | 1024 MB | | CD-ROM | | | FDD | | | Display | 8.9" WSVGA | | Display adapter | Intel GMA950, Max resolution 1024 x 600 | | Battery | Lithium-ion | | Mouse | Touchpad pointing device with two buttons | | Sound | Two built-in stereo speakers, Built-in digital microphone | | | | | PCMCIA | Multi-in-1 card reader
Supporting Secure Digital (SD) Card, MultiMediaCard (MMC), Memory Stick (MS), Memory Stick PRO (MS PRO), xD-Picture Card (xD) | | Interfaces | 3 x USB, 1 x VGA, 1 x Microphone jack, 1 x Headphone jack | | | | | Other | Sapphire Blue, Webcam, Storage expansion: SD Card reader |  |
| | | (For quantity orders) |
|
|
