Suppose you had two tables: tbl1 and tbl2. Both has unique(user). If I wanted to get a list of users that weren't in both tables, how would that be done in a single query? I know that tbl1.user = tbl2.user will give me the ones that ARE on both lists... tlb1.user != tbl2.user will give me lots of repeats (sizeof(tbl1) * sizeof(tbl2)-1). So how would you get this to work in one query? Or can PHP do something about this?
Matching tbl1.a with tbl2.a
- Thread starter wxdqz
- Start date