You start explaining what you need and work backwards, on the other end, they work in reverse, because that's how it's stored.
Conceptually, it's like piping in bash, "find | grep | cut". Start with finding the files(tables), grep for the row data (where), cut the fields you want returned (select).
You start explaining what you need and work backwards, on the other end, they work in reverse, because that's how it's stored.
Conceptually, it's like piping in bash, "find | grep | cut". Start with finding the files(tables), grep for the row data (where), cut the fields you want returned (select).