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="*";
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
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
