Posted by Jerry Stuckle on 03/22/06 04:49

no.mail.pls wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:Qd6dnT4CVp__d4LZnZ2dnUVZ_vidnZ2d@comcast.com...
>
>>no.mail.pls wrote:
>>
>>>"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>>>news:FOqdnaQ40Ly9L4fZRVn-rw@comcast.com...
>>>
>>>
>>>>no.mail.pls wrote:
>>>>
>>>>
>>>>>Hiya,
>>>>>
>>>>>How do i retreive fields with similar values from 2 tables?
>>>>>
>>>>>I tried to use
>>>>>(1) "SELECT * FROM $table1 as o , $table2 as p WHERE o.name like
>>>>>'%p.name%'";
>>>>>but it retrieves nothing at all.
>>>>>
>>>>>(2) "SELECT * FROM $table1 as o , $table2 as p WHERE o.name like
>>>>>p.name";
>>>>>will retrieve exact matches only, but this is not what i want.
>>>>>
>>>>>(3) SELECT * FROM $table1 as o , $table2 as p WHERE o.name LIKE
>>>>>CONCAT('%',
>>>>>p.name, '%');
>>>>>will retrieve exact matches only.
>>>>>
>>>>>Any advice will be appreciated.
>>>>>
>>>>>PostScript: i posted the above in mysql groups, but problem remains, so
>>>>>am trying my luck here.
>>>>>
>>>>>TIA
>>>>
>>>>You've also asked this in (at least) comp.databases.mysql and
>>>>alt.comp.databases.mysql (where is is much more appropriate).
>>>>
>>>>And please learn how to cross-post.
>>>
>>>
>>>Pethaps to x-post or not is a choice between the devil and the deep blue
>>>sea, even though not all of us believe in devils, and some of us love the
>>>deep blue sea.
>>>
>>>Tiptoeing gently among the mines in Usenet can be a tricky bizness.
>>>
>>>cheers
>>>
>>
>>And people who want answers should follow usenet conventions - which
>>includes cross-posting instead of multi-posting.
>
>
> Perhaps it is more accurate to say that it includes, as well as excludes,
> x-posting. Sell not the devil short.
>
> cheers
>
>
>
>

Only in your book does it include multi-posting to multiple newsgroups.

If you want the help, follow the conventions. Otherwise soon you won't
be able to get any responses to any of your questions.

Remember - we're all volunteers here. None of us are being paid to help
you. And we don't have to.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]