On Monday, 20. May 2002 19:58, SpyProductions Support Team wrote:
> Shouldn't this come up with a list of names from each table that matches?
>
>
> SELECT * FROM table1,table2 WHERE table1.name = table2.name;
>
>
> Does anyone see anything wrong with this query? It keeps giving me an
> empty set
Hi.
On Mon, May 20, 2002 at 03:15:44PM -0400, [EMAIL PROTECTED] wrote:
[...]
> > > SELECT * FROM table1,table2 WHERE table1.name = table2.name;
[...]
> > Else, try to create a test case. I.e. try to create a minimal set of
> > SQL commands which will produce the strange behaviour in order to
> >
> Hi.
>
> On Mon, May 20, 2002 at 01:58:25PM -0400,
> [EMAIL PROTECTED] wrote:
> >
> > Shouldn't this come up with a list of names from each table
> that matches?
> >
> > SELECT * FROM table1,table2 WHERE table1.name = table2.name;
> >
> > Does anyone see anything wrong with this query?
>
> No.
>
Hi.
On Mon, May 20, 2002 at 01:58:25PM -0400, [EMAIL PROTECTED] wrote:
>
> Shouldn't this come up with a list of names from each table that matches?
>
> SELECT * FROM table1,table2 WHERE table1.name = table2.name;
>
> Does anyone see anything wrong with this query?
No.
> It keeps giving me a
