Hi All,
Given this table:
+-+-+++-
|sip_status | sip_method | sip_callid | username |
fromtag| totag
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
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,
I working on a small my
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
Jeff,
What i want to do seems simple, but i can not for the life of me
figure out
how to do it.
Tables: These tables are not related in any way.
A
--
1
2
3
4
5
B
--
1,Bob
3,Jack
7,Janet
8,Gary
9,Kelly
I would like to combine tables A and B with a SELECT statement to get
sec)
mysql
From: Jeff Habermann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Help with JOIN query
Date: Thu, 28 Mar 2002 17:16:05 -0800
What i want to do seems simple, but i can not for the life of me figure
out
how to do it.
Tables: These tables are not related in any way
What i want to do seems simple, but i can not for the life of me figure out
how to do it.
Tables: These tables are not related in any way.
A
--
1
2
3
4
5
B
--
1,Bob
3,Jack
7,Janet
8,Gary
9,Kelly
I would like to combine tables A and B with a SELECT statement to get this:
SELECT
--
1,1,Bob