RE: Select not producing desired results

2003-07-09 Thread Andrew Braithwaite
Hi, If you send a table def (mysqldump would be good) I will be able to experiment and come up with an answer... Cheers, Andrew -Original Message- From: Patrick Shoaf [mailto:[EMAIL PROTECTED] Sent: Wednesday 09 July 2003 20:30 To: [EMAIL PROTECTED] Subject: Select not producing desire

Re: Select not producing desired results

2003-07-09 Thread Patrick Shoaf
Thanks, worked perfectly! At 04:17 PM 7/9/2003, gerald_clark wrote: fsttik has dashes in it and your having does not. Either add dashes to your having or change the alias to min(datein+0) as fsttik. Patrick Shoaf wrote: I am trying to get a SELECT working and not having any luck, can someone

Re: Select not producing desired results

2003-07-09 Thread gerald_clark
fsttik has dashes in it and your having does not. Either add dashes to your having or change the alias to min(datein+0) as fsttik. Patrick Shoaf wrote: I am trying to get a SELECT working and not having any luck, can someone please help? SELECT strref,acc.acctno,acc.namelast,acc.namefirst,ph