To access data from a multi-tenant table, mtcustomer:

SELECT * FROM Pub.mtcustomer;

The above select statement returns the column values from the rows in the all the tenant partitions.