On 01.03.2001 13:16:47 soon chee keong wrote: > Table_A: ID APPL > ------------ > B BI > A BII > * * > * * > C BII > * * > D BI > > Table_B: Cnty ID > ------------ > US C > Aus A > Aus B > US D > > * signifies no data > > why does the following produce an error: 1052?? > > SELECT DISTINCT APPL FROM Table_A, Table_B WHERE Table_A.ID=Table_B.ID AND > Cnty="US" AND ID="*"; Which ID? ID from Table_A, or ID from Table_B? --------------------------------------------------------------------- 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