Joining 2 Tables

[nikko50]

Hello friends. What type of join should I use for 2 tables where the joined tables may or may not have equal records but I would still like all records from both tables. In the below mysql the "pohistory" table may have rows = to podetails.id.

select *, sum( pohistory.quantity ) AS 'receivedsum'
FROM podetails
JOIN pohistory ON podetails.id = pohistory.podetailid
where podetails.ponum='$line[ponum]'
GROUP BY pohistory.podetailid";

[Roger_Ramjet]

Use a LEFT JOIN, missing entries in the podetails will be returned as NULL values in the podetails columns.