Sub selects are not yet supported. Please read the manual. A normal query
should also do the trick as well.
> select t1.service_nm from servicecntr_nm
> t1,service_prod_index t2 where t1.serv_cod=t2.serv_cod and t2.prod_no=11
and
> t1.city_cod='in000501';
----- Original Message -----
From: "anirban roy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 10:43
Subject: Problem in a particular Query
> we have two tables
> 1. servicecntr_nm
> comp_cod int(11)
> service_nm varchar(70)
> city_cod varchar(13)
> addr varchar(100)
> pin int(11)
> contact varchar(70)
> serv_cod varchar(30)
> 2.service_prod_index
> serv_cod varchar(30)
> prod_no varchar(20)
>
>
> now our aim is to find out all the service_nm that
> have
> match the city_cod of table 1 and all those all those
> serv_cod that have a particular prod_no of table2
>
> we tried this query:
> select servicecntr_nm.service_nm from servicecntr_nm
> t1,service_prod_index t2 where (t1.serv_cod=(select
> t2.serv_cod from t2 where t2.prod_no=11) and
> (t1.city_cod='in000501');
> the error message is 1064 syntax error in the nested
> sql query
>
> hope you would help,
> Regards,
> Anirban Roy
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great prices!
http://auctions.yahoo.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