Re: right join
| From: | Bastian Vogt | Date: | Thu, 21 Nov 2002 09:28:40 +0000 |
| Subject: | Re: right join | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23556@lists.php.net to get a copy of this message | ||
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);