RE: mysql query help

2002-06-06 Thread Scott Raley
espond to [EMAIL PROTECTED] To: Scott Raley/LPEC/ASD/SEMCORINC@SEMCOR INC., [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: RE: mysql query help I've not looked over your query in-depth so I may be off-base here. Try removing the parentheses from the FROM clause and see if th

mysql query help

2002-06-06 Thread Scott Raley
I need some help... The query below runs fine in access, when running it in mysql it tells me the column wrainfo.wuc doesn't exist in the having clause.. can't figure out why its giving me this error. the column is in the select statement... any ideas? The column does exist.. I'm looking at th

Error 28

2002-05-06 Thread Scott Raley
I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm trying to add an auto_increment ID field to 2 tables that already have data in them.. 1 table worked fine, the other table I get "Got Error 28 from Table Handler" can anyone tell me why I get this? TIA --