Re: complex Subquery

2003-06-04 Thread Bruce Feist
surabhi sinha wrote: Ihave the following subquery which i intend to use for mysql4.0.12 can u tell me how it could be formed for use since no common column is there for it to be converted to Inner join What about Companyid? Select CompanyName,City from Company where CompanyName='Arihant Jain' an

Re: complex Subquery

2003-06-04 Thread Daniel Kasak
surabhi sinha wrote: Dear sir, Ihave the following subquery which i intend to use for mysql4.0.12 can u tell me how it could be formed for use since no common column is there for it to be converted to Inner join Select CompanyName,City from Company where CompanyName='Arihant Jain' and City='Delh