Re: Why is this a cross join? - Mailing list pgsql-general

From Tim Uckun
Subject Re: Why is this a cross join?
Date
Msg-id CAGuHJrMW0DJmxa-cFwVuzAVrBMDaa86eGieZwJPXYntV8L9uuA@mail.gmail.com
Whole thread Raw
In response to Re: Why is this a cross join?  (Alban Hertroys <haramrae@gmail.com>)
Responses Re: Why is this a cross join?  (Tony Theodore <tony.theodore@gmail.com>)
List pgsql-general
> Apparently the first 6 characters of those fields are quite common, which
> gives you a result for every possible combination of the same 6-character
> value.


Mmmmm. That seems kind of weird.   Is there any way to NOT have this
be a cross join?  For example if I extracted the first six characters
into a field and then joined on them it would not be a cross join
right?

pgsql-general by date:

Previous
From: Satoshi Nagayasu
Date:
Subject: Re: Visual query builder for PosgreSQL?
Next
From: Tony Theodore
Date:
Subject: Re: Why is this a cross join?