Hello Everyone, I haven't used SQL in a long time and I am having trouble designing the query to get the result I need. I have 1 select query that looks like this: SELECT WC.FIRST_NAME & ' ' & WC.LAST_NAME AS NAME, C.COMM_NO AS PHONE FROM WRK_CNTRCTR AS WC, WRK_COMM_NUMBER AS C WHERE WC.PERS_ID = C.PERS_ID AND C.COMM_TYPE = 'Telephone';
This returns: Name Phone Michele Memon 212-290-8848 My second selecyt query looks like this: SELECT WC.FIRST_NAME & ' ' & WC.LAST_NAME AS NAME, C.COMM_NO AS EMAIL FROM WRK_CNTRCTR AS WC, WRK_COMM_NUMBER AS C WHERE WC.PERS_ID = C.PERS_ID AND C.COMM_TYPE = 'Email'; Name Email Michele Memon [EMAIL PROTECTED] I would like the result to look like this: Name Phone Email Michele Memon 212-290-8848 [EMAIL PROTECTED] Can someone point me in the right direction? Thanks.... Michele Memon Developer [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php