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