User Profile

Collapse

Profile Sidebar

Collapse
Thao
Thao
Last Activity: May 7 '11, 10:35 AM
Joined: Apr 4 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Thao
    started a topic About syntax
    in SQL Server

    About syntax

    Hi,
    Could you please help me to find my syntax errors in the query below:
    Code:
    select avg(hd) as AVG_HD
from (Product inner join PC on Product.model=PC.model) T
where exists (select * from Product where type='Printer' and T.maker=maker)
    Thanks in advance!
    See more | Go to post
    • Thao
      started a topic Need help for NOT EXISTS query
      in SQL Server

      Need help for NOT EXISTS query

      Hi,
      With these tables:

      Supplier (SNO, SName, Status, City)
      Part (PNO, PName, Color, Weight, City)
      Shipment (SNO, PNO, Qty)

      How can I find the suppliers who have shipped each and every part type. Only use NOT EXISTS.
      Thanks.
      See more | Go to post
      No activity results to display
      Show More
      Working...