用于从两个相关表获取数据的sql查询

I have two tables, employee and inventory. One employee can have zero or more inventories. I would like to list employee information along with at most one inventory information and count of inventories belongs to one employee.I have two tables, employee and inventory. One