Your two Title fields are not the same size.
This could prevent a match.
It will slow down joins in 3.22.
Carl Schrader wrote:
>
> I have 2 tables with a common field of Title.
>
> Table 1 defined as:
> Name;varchar(60)
> Title;varchar(60)
> Year;varchar(4)
> Other;varchar(30)
> Other2;varchar(30)
> act_no;int(8) unsigned zerofill
>
> Table 2 defined as:
> MM;varchar(4)
> Title;varchar(48)
> Archive;varchar(4)
> record_num;int(8) unsigned zerofill
>
> I need to search Table 1 for an persons name. ie. searching Table 1 for
> Tom Hanks may return:
> Green Mile
> Cast Away
>
> and then I need to find out how many individual items for each title are
> in Table 2.
> ie return
> Green Mile 10 35mm 6 16mm
> Cast Away 4 35mm 20 BETA
>
> I have it working by using 2 seperate select calls. I'd like to use
> join, if possible, to speed this process up.
>
> TIA!
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
