the from clause can generally be anything that returns a rowset, a table, view, function, or system-provided information like the information schema, which is typically running proprietary commands and returning the information in a table form.