On Sunday 14 November 2004 05:05 pm, kalin mintchev wrote:
> can somebody please explain what is wrong with this command:
> select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2
> where t2.chain like "%carmike%");

If your no usiing 4.1, subselects are not even allowed.. 

If so.. select * needs to be a field.. like zip.

Jeff

-- 
=======================================================================
Jabber: tradergt@(smelser.org|jabber.org)
Quote:   I don't miss deadlines, I ignore them.
=======================================================================

Attachment: pgpI8LIA5DFZV.pgp
Description: PGP signature

Reply via email to