MySQL Forums
Forum List  »  General

Re: Self-Join
Posted by: Jan Theodore Galkowski
Date: November 12, 2004 06:23PM

Not sure what you're trying to do here, Rakesh. Apart from syntax errors like

Inner Join stringtable.link

and mentioning integertable in the WHERE clause but not in the FROM, do you mean something like:

select distinct s1.sourceId
from samplesettable s1, samplesettable s2, stringtable s3, integertable i
where i.link = s2.link
and s1.link = s3.link
and i.name = 'someIntegerVariablesName'
and s3.name = 'SomeStringVariableName' ;


?

Jan Theodore Galkowski (o°)
jtgalkowski@alum.mit.edu
http://www.thesmalltalkidiom.net/

The Smalltalk Idiom
laboratory workflow software
PHP,ANSI SQL,relational designs
Internet engineering

Options: ReplyQuote


Subject
Written By
Posted
November 11, 2004 11:21PM
Re: Self-Join
November 12, 2004 06:23PM
November 12, 2004 07:24PM
November 12, 2004 07:33PM
November 13, 2004 12:41AM
November 13, 2004 05:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.