I've got a problem trying to query data from our db. What
I need is a uniqe ID for the results. What I am getting
is duplicate ID's.
What I need:
RCIID | pending_id | Name | move_out_date
321 420 Jeff Borden 2003-08-20
323 429 Todd McFarlane 2003-08-11
What I actually get:
RCIID | pending_id | Name | move_out_date
321 420 Jeff Borden 2003-08-20
321 421 Jeff Borden 2003-08-07
323 429 Todd McFarlane 2003-08-11
My query looks like:
SELECT
DISTINCT(Pending_Main.RCIID),
Pending_Main.pending_id,
Renter.Name,
Pending_Move_Outs.move_out_date
FROM
Pending_Move_Outs INNER JOIN (Pending_Main INNER JOIN
Renter
ON (Pending_Main.RCIID = Renter.RCI_ID))
ON Pending_Move_Outs.pending_id = Pending_Main.pending_id
WHERE
Pending_Main.Property_Number = '123'
AND Pending_Main.pending_action = 'o'
I also tried the following but got the same result:
SELECT
Pending_Main.unit_number,
Pending_Main.RCIID,
Renter.Name,
Pending_Move_Outs.move_out_date
FROM
Pending_Main,
Renter,
Pending_Move_Outs
WHERE
Pending_Main.Property_Number = '123'
AND Pending_Main.pending_action = 'o'
AND (Pending_Main.RCIID = Renter.RCI_ID)
AND (Pending_Main.pending_id =
Pending_Move_Outs.pending_id)
PLZ Help me. Thank you...
