Member Avatar for Shodow

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
  • 239 Views
  • 32 Minutes Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for Shodow

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

Member Avatar for pritaeas

from sales,customer

You are selecting from two tables without a join. That causes such behaviour.

Member Avatar for Shodow

how can i fix it?

Member Avatar for pritaeas

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

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.