SQL query to combine data from multiple tables to create one master table?

Hi! I'm a SQL newbie and I'm working on database for an electronic store inventory and I need help Below are my schema:

-Product(sku, brand, model, type)
-Camera(sku, quantity, price)
-Cellphone(sku, quantity, price)
-Printer(sku, quantity, price)
-Laptop(sku, quantity, price)

**Note-I'm using the SKU # as the primary key to join each product type (camera, printer, laptop, desktop) table to the "Product" table.

I would like to have a table of all the inventory in the store (a listing of All the item/products available in the store), I have the following query, but I'm stuck on the Select clause and I'm not sure if my Where clause is correct. In the Select clause, I'm not sure how to call the quantity and price column for each different item correctly.

Select p.sku, p.brand, p.model, p.type, //incomplete-needs help
From Product p, Camera c, Printer pr, Laptop l, Cellphone ce
Where p.sku = c.sku AND p.sku = pr.sku AND p.sku = l.sku AND p.sku = ce.sku //needs verification
Group by p.type;

The result table that I want to have:

SKU | brand | model | type | Quantity | Price |
12345 | Canon | PowerShot | SX500 | Camera | 25 | 146.26
67890 | Nikon | Coolpix L810 | Camera | 15 | 135.00
89012 | Apple | iPhone 5S | Cellphone | 45 | 40 | 650.00
34567 | Samsung | Galaxy S4 | Cellphone | 20 | 580.00
45678 | Apple | MacBook Pro | Laptop | 10 | 1800.00
90123 | Microsoft | Surface Pro 2 | Laptop | 10 | 1000.00
78901 | Dell | B1160w | Printer | 15 | 93.00
23456 | HP | Officejet Pro 8600 | Printer | 10 | 199.99

Use JOIN for Product table and each product table, then UNION them.
see explation about join here:
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
and about union here:
http://www.techonthenet.com/sql/union.php

  • What is the difference btw apple real iphone and iphone clone or master copy? Now a days some people r making fake apple iphone. I want to buy an iphone 4s and i saw some iphone clone too. So how can i be sure which one i'm buying real one or the fake one? For the record i want to buy real apple iphone. So i need to know some trick to figure it out which one is real. So that i can assure myself that i'm buying real one.
  • What is dpkg-query on iphone? I downloaded an app on my iphone called "carat" that says what uses the most battery on your phone and it says that "dpkg-query" uses a bit of life. I'm jailbroken if that helps. What is this? How do I fix it.
  • Virtual Table Tenis 3 Hack iPhone Working? Any Cheats? - 1 Greetings I wish to get Virtual Table Tennis 3 hack… I want to use it in my iPhone4 My device has untouched soft so it'd be great if anyone was able to help me
  • Query related to Dropbox/ iPhone 4s? I've transferred pics of my recent trip to Kashmir to Dropbox on my iPhone. If i delete the pics from the iPhone Photo Folder (to make space), will they still be there on the Dropbox? I wouldn't want to lose them, so could someone please help?