Thanks,
OK, I think I see where I was going wrong! :) We'll work at it again.
Appreciate the help from the list.
On Thu, 06 Sep 2001 01:27:21 +0200, Henning Schroeder <[EMAIL PROTECTED]>
wrote:
>>>>okay,
>>>>
>>>>"extract all the tagnumbers,days and expdate"
>>>>
>>>>select tagnumber, days, expdate from membership, tags
>>>>
>>>>"where the orderid equals the tagid"
>>>>
>>>>where orderid=tags.tagid and tags.tagid=membership.id;
>>>>
>>>>
>>>>i´m not quite sure if I understood you correctly. above query gets you your
>>>>data joining the tables together on identical tagids and selecting all rows
>>>>where tags.tagid=tags.orderid. is that what you wanted? otherwise, ask...
>>>>
>>>>greetings,
>>>I got a sql query I seemed to be missing the obvious or just can't see.
>>>Database Table structure:
>>>CREATE TABLE `membership` (
>>> `tagid` int(8) NOT NULL default '0',
>>> `startdate` date NOT NULL default '0000-00-00',
>>> `expdate` date NOT NULL default '0000-00-00',
>>> `days` smallint(4) NOT NULL default '0',
>>> PRIMARY KEY (`tagid`),
>>> KEY `days` (`days`)
>>>)
>>>
>>>CREATE TABLE `tags` (
>>> `tagid` int(8) NOT NULL auto_increment,
>>> `orderid` int(8) NOT NULL default '0',
>>> `finderid` int(8) NOT NULL default '0',
>>> `tagnumber` varchar(10) NOT NULL default '',
>>> PRIMARY KEY (`tagid`),
>>> UNIQUE KEY `tagnumber` (`tagnumber`),
>>> KEY `orderid` (`orderid`,`finderid`)
>>>);
>>>
>>>What I need to do is extract all the tagnumbers,days and expdate where the
>>>orderid equals the tagid in both the "tags" and "membership" tables.
>>
>>
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
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