How does preceeding load know how to stop loading tables?

[#1]

Quick question I am using preceeding load which is very useful but how do you stop a table beneath the preceeding load being included?

[vgutkovsky]

A preceding load will stop when it hits a semicolon that is located after the next table. For example:

LOAD
CategoryID,
CategoryName,
Description;
SQL SELECT *
FROM Categories;

In this example, the first semicolon (after Description) will stop the preceding load and the second semicolon (after Categories) will tell the preceding load where to get data from. Other data sources than SQL only require the second semicolon.

Hope this helped,