Re: Error 1052:Query problem

2001-03-01 Thread Rolf Hopkins 

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
>  
>   USC
>   Aus   A
>   Aus   B
>   USD
>
> * 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

Antwort: Error 1052:Query problem

2001-03-01 Thread alexander . skwar 


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
>  
>   USC
>   Aus   A
>   Aus   B
>   USD
>
> * 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

Error 1052:Query problem

2001-03-01 Thread soon chee keong 

Table_A:  ID   APPL
 
  B BI
  A BII
  *  *
  *  *
  C BII
  *  *
  D BI

Table_B:  Cnty  ID
 
  USC
  Aus   A
  Aus   B
  USD

* 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