// Function to obtain data and populate in DataGridView
private void displayCustomers()
{
DataInterface.DBOpen();
// Query to select desired information to display
String query = "SELECT c.customerId AS ID, c.customerName AS Name, c.active AS Active, a.address AS Address, a.address2 AS Address2, a.city AS City, a.postalCode AS 'Postal Code', a.country AS Country, a.phone AS Phone " +
"FROM customer AS c, (SELECT address.addressId, address.address, address.address2, address.postalCode, address.phone, city.city, country.country FROM address, city, country WHERE address.cityId = city.cityId AND city.countryId = country.countryId) AS a " +
"WHERE c.addressId = a.addressId";
// Pass query and desired DGV to function to obtain data and populate
DataInterface.displayDGV(query, customersDGV);
}
