Refer to the following SQL statement and identify the type of query: SELECT * FROM Projects WHERE ProjectID IN (SELECT ProjectID FROM PeopleProjects);

Refer to the following SQL statement and identify the type of query: SELECT * FROM Projects WHERE ProjectID IN (SELECT ProjectID FROM PeopleProjects); › Category: Introduction to Linux II › Author "LinuxQuestions" › Refer to the following SQL statement and identify the type of query: SELECT * FROM Projects WHERE ProjectID IN (SELECT ProjectID FROM PeopleProjects);

Vote Up 0 Vote Down

Linux Questions Staff asked 1 year ago

Refer to the following SQL statement and identify the type of query:
SELECT * FROM Projects WHERE ProjectID IN (SELECT ProjectID FROM PeopleProjects);

Simple query
Sub query
Outer join
Structured query

You may also like

About the author