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
