MySQL

Question about SELECT statement

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2005

Posts: 92

Reputation: michael123 is an unknown quantity at this point

Solved Threads: 0

michael123 michael123 is offline

Offline

Junior Poster in Training

Question about SELECT statement

Oct 16th, 2006

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.

•

Join Date: Jun 2005

Posts: 92

Reputation: michael123 is an unknown quantity at this point

Solved Threads: 0

michael123 michael123 is offline

Offline

Junior Poster in Training

Re: Question about SELECT statement

Oct 16th, 2006

I got the answer, thanks.

Quick Reply to Thread

Show Printable Version

Similar Threads

Question about SELECT statement (MS SQL)
Hi,Need help on sql select statement structure (MS SQL)
Question about select statement (MySQL)
Question about SELECT statement (MySQL)
select statemt LIKE (MySQL)
Getting current value in Select Statement (MS SQL)
Program Problem with a select statement to access Data base (C)

Other Threads in the MySQL Forum

Previous Thread: I NEED HELP PLEASE:Warning: mysql_num_rows():
Next Thread: Daily Auto MySQL Backup saved to directorty

Views: 1266 | Replies: 1

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes