Member Avatar for bhavna_816

I am joining two tables with INNER JOIN and I am getting duplicate entries.
I used DISTINCT but its not working.
Do we have some other keywords for the same?


Thanks in advance,

  • 3 Contributors
  • 2 Replies
  • 64 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by tesuji
Member Avatar for lich

what is the tables you joining and what are the entries u getting again after joining. if u can make another field and put it as pk in that new table

Member Avatar for tesuji

If you expect serious answer, you have to show your exact tables definitions first.

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.