Posted by Jerry Stuckle on 11/18/99 11:43

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.

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

[Back to original message]