Need query help... urgent plz....

[write2ashokkumar]

Hi,

i have the table like this,

+------+------+------+
| uid | val | type |
+------+------+------+
| 1 | 500 | 1 |
| 1 | 500 | 2 |
| 2 | 500 | 1 |
| 2 | 100 | 2 |
| 3 | 100 | 2 |
| 4 | 500 | 1 |
+------+------+------+


here, type 1 = sales and type 2 = return

i want to select only the sales record for the users, without return

expecting output
+------+------+------+
| uid | val | type |
+------+------+------+
| 4 | 500 | 1 |
+------+------+------+

Thanks,
S.Ashokkumar

[coolsti]

What have you tried so far? Where do you have problems?

What you are asking for is about the most basic SELECT query that one can imagine.