Stephan Szabo wrote:
Probably you want something like:
SELECT u.uid, u.txt, p.val FROM
u INNER JOIN a ON (a.id=u.aid)
LEFT JOIN p ON (p.uid=u.uid AND p.pkey=a.pkey);
From the docs:
A CROSS JOIN or INNER JOIN is a simple Cartesian product, the same as you get from
listing the two items at the
On Tuesday 26 August 2003 02:58, Joseph Shraibman wrote:
How can I join on one table with join conditions refering to two tables?
In this example p is missing an entry that corresponds to u. I want to
select from u and p, but have entries in u that don't have an entry in p.
The problem is I
On Mon, 25 Aug 2003, Joseph Shraibman wrote:
How can I join on one table with join conditions refering to two tables? In this
example
p is missing an entry that corresponds to u. I want to select from u and p, but have
entries in u that don't have an entry in p. The problem is I need to