# \#Vendors

**URL:** https://www.dolibarr.org/forum/tag/vendors/51.md

[Latest](https://www.dolibarr.org/forum/latest.md) · [Categories](https://www.dolibarr.org/forum/categories.md) · [Tags](https://www.dolibarr.org/forum/tags.md)

---

## [How do i link the Purchase Order with Vendor Invoice in SQL?](https://www.dolibarr.org/forum/t/how-do-i-link-the-purchase-order-with-vendor-invoice-in-sql/21320)

<div class="topic-metadata">

**Author:** [@kodycarl](https://www.dolibarr.org/forum/u/kodycarl)\
**Replies:** 6\
**Last updated:** [October 17, 2021, 12:01pm UTC](https://www.dolibarr.org/forum/t/how-do-i-link-the-purchase-order-with-vendor-invoice-in-sql/21320 "2021-10-17T12:01:48Z")

</div>

Hello, How do i link the Purchase Order with Vendor Invoice in SQL ? i look in the llx\_commande\_fournisseur table and the llx\_facture\_fourn table and i dont see a link to JOIN on. Please help.
