Expand|Select|Wrap|Line Numbers
- SELECT departments.department_name AS "Department name", locations.STREET_ADDRESS AS "Mailing address", locations.city, locations.state_province, locations.postal_code
- FROM departments, locations
- WHERE departments.location_id = locations.location_id
- AND locations.country_id = 'US'
- ORDER BY department_name;
Expand|Select|Wrap|Line Numbers
- Department name Mailing address
- ------------------------------ ----------------------------------------
- CITY STATE_PROVINCE POSTAL_CODE
- ------------------------------ ------------------------- ------------
- Administration 2004 Charade Rd
- Seattle Washington 98199
- IT 2014 Jabberwocky Rd
- Southlake Texas 26192
Expand|Select|Wrap|Line Numbers
- Department Name Mailing Address
- ---------------------- -----------------------------------------------------
- Administration 2004 Charade Rd, Seattle, Washington 98199
- IT 2014 Jabberwocky Rd, Southlake, Texas 26192
Thanks for your time.
PS: it doesn't matter if the displayed data is folded because of the number of lines allowed.