Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@localhost:~
- -> mysql simplifymd_production
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 8
- Server version: 5.0.88-community MySQL Community Edition (GPL)
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> select
- -> concat(p.first_name,', ',p.last_name) as 'Name (Last, First)',
- -> c0.address as 'Email Address',
- -> c1.phone_number as 'Home Phone',
- -> c2.phone_number as 'Mobile Phone',
- -> concat(c3.address,', ',c3.state_abbreviation,' ',c3.postal_code) as 'Postal Address'
- -> from party p
- -> left join communication_channel c0 on c0.type='EmailAddress' and c0.party_id=p.id
- -> left join communication_channel c1 on c1.phone_number_type_id=1 and c1.party_id=p.id
- -> left join communication_channel c2 on c2.phone_number_type_id=14 and c2.party_id=p.id
- -> left join communication_channel c3 on c3.type='PostalAddress' and c3.party_id=p.id
- -> where p.type='Patient';
- +--------------------+--------------------------------+--------------+--------------+----------------------------------+
- | Name (Last, First) | Email Address | Home Phone | Mobile Phone | Postal Address |
- +--------------------+--------------------------------+--------------+--------------+----------------------------------+
- | Emma, Peel | emma.peel.sMD@gmail.com | 770-965-1122 | 770-965-2255 | 831 Arlene Ave., GA 30071 |
- | Martha, Smith | martha.smith.sMD@gmail.com | 678-965-5431 | 706-765-3877 | 6538 West Dover, GA 30024 |
- | Richard, Johnson | richard.johnson.sMD@gmail.com | 770-429-5243 | 770-981-9821 | 215 Wilson St., GA 30040 |
- | Jackie, Roberts | jackie.roberts.sMD@hotmail.com | 404-556-8734 | 219-998-0265 | 4190 Park Place, GA 30269 |
- | Timothy, Burnett | NULL | 770-456-3920 | NULL | 3436 Phillips Ave., GA 30281 |
- | Kimberly, Wellman | kimberly.wellman.sMD@gmail.com | 770-898-2457 | 219-766-5541 | 1128 S. St. Rd. 49, GA 39870 |
- | Lee, Adams | NULL | 770-879-2354 | 770-932-4040 | 7543 Summer Dr., GA 30004 |
- | Mary Anne, Jones | NULL | 770-998-4231 | 219-874-3498 | 575 East Ridge Road, GA 30281 |
- | Cam, Piaz | NULL | 312-755-5588 | NULL | 87063 Westbrook Place, GA 30337 |
- | Candice, Harper | candice.harper.sMD@gmail.com | 219-998-2211 | 219-996-2020 | 7765 Highbrook Ct., GA 30252 |
- | Angela, Mason | hlinak@gmail.com | 455-663-1190 | 456-663-1110 | 1285 Hodges Lane, GA 30075 |
- | Brandon, Willis | brandon.willis.sMD@gmail.com | 489-232-1595 | 480-232-7385 | 967 Lake Hills Dr., GA 30062 |
- | Ginny, Smith | numeraltwo@yahoo.com | 956-548-5000 | 956-546-4021 | 8 Finnigan Trail, TX 78520 |
- | June, Murray | NULL | 770-939-7879 | NULL | 215 Quail Run, GA 30076 |
- | Greta, Stuart | NULL | 770-939-9787 | 678-939-9393 | 2 Crabapple Meadow, GA 30004 |
- | Matt, Ellington | NULL | 770-644-4848 | 678-433-4227 | 47 Ripplewood Drive, GA 30005 |
- | Lester, Waters | NULL | 439-556-3030 | 439-232-5050 | 2834 Oakwood Park, GA 30026 |
- | EOB, EOB | NULL | NULL | NULL | NULL |
- | Invoices, Invoices | NULL | NULL | NULL | NULL |
- +--------------------+--------------------------------+--------------+--------------+----------------------------------+
- 19 rows in set (0.01 sec)
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement