Jim S-T
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by Jim S-T
-
-
Hi,
I am slowly making my way through the SQL tutorial and have got a bit stuck on the exists tutorials. This is one of the examples, but I do not understand why they have used SELECT ProductName.
SELECT supplierid, SupplierName
FROM Suppliers
WHERE EXISTS (SELECT ProductName FROM Products WHERE SupplierId = Suppliers.supplierId AND Price < 20);When running SQL it provides 2 columns, supplier ID and Supplier Name as per the 1st line. I have replaced ProductName with * and get the same results, is it a best practice thing, or have I been getting worked up over not much as they just needed something to fill the space?
Thanks
Jim
-
Hi,
I am using your tutorials because I currently have no SQL experience. I have just got to your SQL Update tutorial and updated all the contact names to Juan. You have asked that i restore the database, however have not told me how to restore it, I have tried typing in restore and after looking on google tried Roll Back, but I must be missing a command because neither of these is resetting the database.
Any help restoring the database would be much appreciated.
Many thanks
Jim
Exists operator
in SQL
Posted
Thanks