Query advice, please

2002-02-12 Thread Snoofie
Hi: I'd like to store user preferences in one table, such that there are default values but a user can override the preference. Default preferences are stored as user 0. This is trivial to do with two queries, but I'd like to compress it to one. Here's an example of what I mean: +--+--+

Query advice, please

2002-02-06 Thread Snoofie
Hi: I'd like to store user preferences in one table, such that there are default values but a user can override the preference. Default preferences are stored as user 0. This is trivial to do with two queries, but I'd like to compress it to one. Here's an example of what I mean: +--+--+