Member Avatar for michael123

I have two tables:
tb1:
ID USERNAME
1 u11
2 u12
3 u13

tb2:
ID USERNAME
2 u12


My question is how to retrieve records from tb1 and exclude one that is in tb2, so the result will be:
ID USERNAME
1 u11
3 u13

Any comment? Thanks in advance.

  • 1 Contributor
  • 1 Reply
  • 80 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by michael123
Member Avatar for michael123

I got the answer, thanks.

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.