Well, for starters, I would say you need
> Table_B.Cnty="US" AND Table_A.ID="*";
not
> Cnty="US" AND ID="*";
----- Original Message -----
From: "soon chee keong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 20:16
Subject: Error 1052:Query problem
> 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
---------------------------------------------------------------------
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