oups. Downside of this strategy is that
it's not very efficient neither in speed nor with space consumption. And
maintaining integrity using this kind of table layout would be pain..
Any ideas how I could rearrange the data in a way that I could search it by
groups without thi
roup A) How can I
do that?
Not with OR I think.
Any ideas? Or do I just have to take everything out from DB and then
manually
loop through all records in my client code?
Sincerely,
Jouni Hartikainen
[EMAIL PROTECTED]
Jouni Hartikainen wrote:
Hi.
> how about:
>
> select record.*
>
rds that belong to group 3. But what
about if I want to have all records that belong to groups 1 AND 3? If I add
condition "WHERE group_id='1' AND group_id='3'", I get no results at all,
since left join doesn't produce such rows that have multiple
ay to either construct the database
tables or to perform searching queries?
Sincerely,
Jouni Hartikainen
[EMAIL PROTECTED]
_
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featured
