Select CustomerID,SalesID,CustomerName,Num_Of_Bottles,Price,Status from sales,customer where Date = DATE_FORMAT(NOW(),'%b %d, %Y') and CustomerID>0 Order by SalesID DESC
Shodow
3
Junior Poster
Recommended Answers
Jump to PostWhat is the question?
Jump to Postfrom sales,customer
You are selecting from two tables without a join. That causes such behaviour.
All 5 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Shodow
3
Junior Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Shodow
3
Junior Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.