Sql from

This article is tagged with: Sql from and mysql

sql from

Specifies which table to select or delete data from.
Example: Selects data from the users table.
SELECT area_manager
FROM area_managers
WHERE EXISTS (SELECT ProductName FROM Products WHERE
area_manager_id = deals.area_manager_id AND Price < 20);

SQL FROM

FROM-Klausel
SELECT *
FROM tbl_produkte
WHERE price > 100

SQL SELECT WHERE

SELECT column1, column2, ...
FROM table_name
WHERE condition;

This article is tagged with: Sql from and mysql