Jun 17, 2025
Оfftopic Community
Оfftopic Community
Forums
New posts
Search forums
What's new
Featured content
New posts
New media
New media comments
New resources
New profile posts
Latest activity
Media
New media
New comments
Search media
Resources
Latest reviews
Search resources
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
OnTopic Community
MarketPlace
Find out the makers that sale PCs but not laptops.?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="MarkR" data-source="post: 1709476" data-attributes="member: 215263"><p>The database scheme consists of four tables:</p><p>Product(maker, model, type)</p><p>PC(code, model, speed, ram, hd, cd, price)</p><p>Laptop(code, model, speed, ram, hd, screen, price)</p><p>Printer(code, model, color, type, price)</p><p></p><p>i am practicing how to write select queries and i am having trouble with this question. What the question is asking for is a query which will select product.makers of pc's and not laptops. below shows the table product along with what the correct result should look like.</p><p></p><p>http://i262.photobucket.com/albums/ii82/markngaby2/block.jpg</p></blockquote><p></p>
[QUOTE="MarkR, post: 1709476, member: 215263"] The database scheme consists of four tables: Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Laptop(code, model, speed, ram, hd, screen, price) Printer(code, model, color, type, price) i am practicing how to write select queries and i am having trouble with this question. What the question is asking for is a query which will select product.makers of pc's and not laptops. below shows the table product along with what the correct result should look like. http://i262.photobucket.com/albums/ii82/markngaby2/block.jpg [/QUOTE]
Insert quotes…
Name
Verification
Please enable JavaScript to continue.
Loading…
Post reply
Top