Newbie MySql

2002-06-06 Thread Memon, Michele
Hi Everyone. I need to run an extract of some data from our Oracle DB's. One of the restrictions is that I need to write a SQL script that will parse through a particular field for a "/" and if found, I have to remove it and output the data without the slash. I have minor experience with selectin

Recall: Need help with query result

2002-05-30 Thread Memon, Michele
Memon, Michele would like to recall the message, "Need help with query result". - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Need help with query result

2002-05-30 Thread Memon, Michele
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 =