954,597 Members — Technology Publication meets Social Media

Have something to say? Contribute New Article Reply to this Article

0

Question about SELECT statement

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.

Junior Poster in Training

94 posts since Jun 2005

Reputation Points: 10

Solved Threads: 0

0

I got the answer, thanks.

Junior Poster in Training

94 posts since Jun 2005

Reputation Points: 10

Solved Threads: 0

This article has been dead for over three months

You

© 2012 DaniWeb® LLC

Home | About Us | Contact Us | Terms of Service | Advertising Opportunities