I have a pieces table with p_id as primary key.
I have a requests table with r_id as primary key.
I have a pieces_requests table with (p_id, r_id) as primary key, and an
indicator pr_ind reflecting the state of that relationship
A single select of details from the pieces table based on an entry
I'll admit I don't see any reason why you should get duplicate rows based
on the data you've provided, but I am wondering why you are using the
subquery instead of just 'where r.r_id = 5695'
select p.p_id, r.pr_ind
from pieces p
join pieces_requests r on p.p_id = r.p_id
where r.r_id = 5695
Hi,
Thanks for this. I did eventually discover the cause being other rows in the
pieces_requests table that I hadn't thought about.
The short answer to your second part is that I don't know why I did it that
way. Presumably when I first wrote it there was a reason.
Gary
On Wednesday 12
This is my first message in this list :)
I need to be able to sort a query by column A, then B or C (which one
is smaller, both are of the same type and table but on different left
joins) and then by D.
How can I do that?
Thanks in advance,
Rodrigo.
--
Sent via pgsql-sql mailing list
Replied just to Samuel and forgot to include the list in my reply. Doing
that now, sorry...
Em 12-09-2012 18:53, Samuel Gendler escreveu:
you put a conditional clause in the order by statement, either by
referencing a column that is populated conditionally, like this
select A, when B C Then