I am having issues with the syntax for dropping multiple table.
I have multiple tables which I have joined and then created a final table where I use all the data and wanted to drop all the other tables but I get a syntax error for DROP TABLES Table1, Table2, Table3; e.g.:
Also with my Table 4: I have used Table1 as Resident but do I need to state Table1, Table2, Table3?
I agree with Marco! Tables consumed in join will be available in data model as separate tables. i.e. Table 2 & Table 3 are joined with Table 1; therefore these tables will not available (distinct fields from both the tables will be part of Table 1).