Returning the first record of an inner join?
805577Oct 14 2010 — edited Oct 15 2010I've been looking all over the internet for an answer for this but I've had no luck so far.
select a.*, b.Part_Name from BOXES_TABLE a
inner join PARTS_IN_THE_BOXES_TABLE b on b.BOX_id = a.BOX_id I can only modify this line
where a.BOX.id = 1234
Is there anyway to limit the inner join to return only one record? I can't use a where statement for it.
I want to return just one part name of the many in a box, but I can't seem to write a join that won't return everything in that box, since the only id I have is for the boxes, and many parts can have the same box id.
If some can show me this I will be the king of work tomorrow.