Re: SQL Join - MySQL/PostgreSQL difference?

Brice Ruth writes:

> SELECT
> a.Number,
> a.Code,
> a.Text
> FROM
> b,
> a
> WHERE
> (b.Id = a.Id) AND
> (VersionId = 'key1') AND
> (Category = 'key2') AND
> (b.d_Id = 'key3')
> ORDER BY
> a.Number;
>
> (my apologies: I had to 'mangle' the table/column names because of NDA)
>
> So my question is this: would this query operate differently in MySQL
> than in PostgreSQL? The reason I ask is that this query in MySQL
> returns results, yet in PostgreSQL it does not.

Without showing the tables and the data in it, it's fairly hard to tell.
I think MySQL does case insensitive string comparisons; check that.

> I read a post about PostgreSQL not supporting outer joins, but I don't
> have enough experience with SQL to determine if this is such a query
> or not. Please advise.

This is not an outer join.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/