hi,
did you try
"...FROM labor RIGHT JOIN works_orders ON labor_ord_no =
works_orders_ord_no WHERE labor_qty='' ORDER BY labor_qty",$link);
?
i think that should do it....
regards,
bastian
> How do I get the following select to exclude records where labor_qty from
> labor does not have a record?
>
> $result = mysql_query("SELECT
> labor_ord_no,works_orders_ord_no,works_orders_part_no,works_orders_qty,labor
> _qty FROM labor RIGHT JOIN works_orders ON labor_ord_no =
> works_orders_ord_no ORDER BY labor_qty",$link);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
