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;