CODEWITHSUNDEEP
mysqlopenbravo
pm.
pm.

Reputation: 225

Making a mySQL-query to get products that have not ben sold?

Using openbravoPOS i got a mySQL database of all my producs tickets stock etc.

Products are in one table and the tickets are in another, so to make a query that get me all the products that are sold (and therefore are in ticketlines) are simple.

How do I make a query that gives me the products that are not i any ticketlines?

Upvotes: 0

Views: 298

Answers (1)

D'Arcy Rittich
D'Arcy Rittich

Reputation: 171511

You can use a LEFT OUTER JOIN for this:

select p.*
from products p
left outer join tickets t on p.ProductID = t.ProductID
where t.ProductID is null

Upvotes: 1

Related Questions