Welcome Guest, Not a member yet? Register   Sign In
I feel stupid asking this question
#11

[eluser]alboyd[/eluser]
[quote author="kgill" date="1251685141"]Just as a follow up, read up on subqueries, unless there's something I'm missing here - there's no reason you had to do this in two different queries.

Code:
select * from table1
where username NOT IN (select username from table2)
[/quote]

Good point!


Messages In This Thread
I feel stupid asking this question - by El Forum - 08-30-2009, 08:23 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 08:38 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 08:51 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 08:57 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 09:12 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 09:22 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 09:24 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 09:35 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 10:36 AM
I feel stupid asking this question - by El Forum - 08-30-2009, 03:19 PM
I feel stupid asking this question - by El Forum - 08-30-2009, 04:53 PM



Theme © iAndrew 2016 - Forum software by © MyBB