0

wqe 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

Edited by Shodow

2
Contributors
5
Replies
6
Views
4 Years
Discussion Span
Last Post by pritaeas
0

why is it duplicating? this is the real result in table but in query it duplicated 150230

0

Hard to say, depends on the information you have and need. You'll need to provide your table structure, sample data and sample output.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.