List:General Discussion« Previous MessageNext Message »
From:kalin mintchev Date:November 15 2004 8:52am
Subject:Re: syntax question..
View as plain text  
>
> ----- Original Message -----
> From: "kalin mintchev" <kalin@stripped>
> To: "Adam" <lists_acc@stripped>
> Cc: "MySQL General" <mysql@stripped>
> Sent: Sunday, November 14, 2004 11:33 PM
> Subject: Re: syntax question..
>
>
>>
>> > Kalin,
>> >
>> > Kalin> thanks to all... yes, Rhino - i'm new. my first
>> > Kalin> post. the version is the problem indeed. it's
>> > Kalin> 4.0.13-standard. how would i achieve the same
>> > Kalin> query in this version?...
>> >
>> > You'll need to provide the following:
>> >
>> > (1) What is the result you want to achieve?
>> well:
>> this is what i wrote:
>> select t1.data from table1 as t1 where t1.zip=(select * from table2 as
>> t2
>> where t2.chain like "%carmike%");
>>
>> i guess this will make more sense:
>> basically i'm looking for the data in t1.data - which is varchar - that
>> has a zip  value of the record(s)  that contain the name "carmike" in
>> their "chain" field in table2...
>>
>> does this make sense?
>>
>
> Not entirely. It sounds like you are saying that the zip value is in the
> column called 'data'. From your query, it appears that the zip code is in
> the column called 'zip'. I *think* you mean to say that for every row in
> table1 that contains a give the same zip code as the zip code of
> '%carmike%', you want to see some other information in the same row, which
> you are calling 'data' in your example.
>
> There are probably a few different ways to do this query. I'm going to
> suggest one possible approach but it is not necessarily the best one;
> others
> may come along later to suggest a better approach.
>
> I think you need to do something like this:
>
> select t1.data
> from table1 t1 inner join table2 t2 on t1.zip = t2.zip
> where t2.chain like '%carmike%';

i tried this one...  it seams to work. i'll read a bit more about joins ..
 thank you... appreciate it...


>
> You haven't provided full descriptions of the tables and their columns and
> I
> have no idea what the data in the tables actually is so I can't try this
> for
> you to be sure it works. However, it should be pretty close to what you
> need. Give it a try and let us know what error messages you get. If you
> don't get error messages but the result is incorrect, describe the result
> that you got and how it differed from the result you expected. Then we can
> probably help you figure out what went wrong.
>
> Rhino
>
>


-- 

Thread
syntax question..kalin mintchev15 Nov
  • RE: syntax question..Peter Lovatt15 Nov
    • RE: syntax question..kalin mintchev15 Nov
      • Re: syntax question..Adam15 Nov
        • Re: syntax question..kalin mintchev15 Nov
      • Re: syntax question..Rhino15 Nov
        • Re: syntax question..kalin mintchev15 Nov
      • Re: syntax question..Rhino15 Nov
  • Re: syntax question..Jeff Smelser15 Nov
  • Re: syntax question..Rhino15 Nov
  • Re: syntax question..Rhino15 Nov