Hello,
I have these two tables,
CREATE TABLE `items` (
`name` varchar(100) NOT NULL default '',
`img` varchar(50) NOT NULL default '',
`year` year(4) NOT NULL default '',
`item_id` smallint(5) unsigned NOT NULL auto_increment,
PRIMARY KEY (`item_id`)
) TYPE=MyISAM;
CREATE TABLE `units`
SELECT * FROM t1,t2,t3 WHERE t1.img_id=t2.img_id AND
t2.caption_id=t3.caption_id
Adolfo
> -Original Message-
> From: mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 19, 2002 8:15 PM
> To: [EMAIL PROTECTED]
> Subject: Help w/ Join Query
>
>
> Hello,
&
Hello,
I working on a small my project to learn more about joins. I have three
tables here is what they look like
CREATE TABLE `album` (
`album_id` smallint(3) NOT NULL auto_increment,
`name` text NOT NULL,
`description` text NOT NULL,
`img_id` smallint(5) NOT NULL default '0',
PRIMARY KEY
