Hi,
I'm trying hard to figure out how to perform a special query in mysql 4.0.
I have one table widgets which has a column widget-id (int) and one
column number_of_parts (int).
And then I have another table part_mapping which has one column
widget-id (int) and one column part_id (int).
part_id
Philip Lawatsch [EMAIL PROTECTED] wrote on 06/06/2005 01:37:37 PM:
Hi,
I'm trying hard to figure out how to perform a special query in mysql
4.0.
I have one table widgets which has a column widget-id (int) and one
column number_of_parts (int).
And then I have another table part_mapping
Philip Lawatsch wrote:
Hi,
I'm trying hard to figure out how to perform a special query in mysql 4.0.
I have one table widgets which has a column widget-id (int) and one
column number_of_parts (int).
And then I have another table part_mapping which has one column
widget-id (int) and one
Unless you are keeping track of whether a widget in complete or not,
there is no hope but to scan the entire table to determine if a widget
is complete. That's something you don't want to do. You should mark a
widget as complete when it is completed. This would mean checking if a
particular
[EMAIL PROTECTED] wrote:
I pretty much have no idea how I can do this without nested queries (and
to be frank not even how to do it with them) so I'd really appreciate
any help!
kind regards Philip
Try this as a starting point:
snip
I think you were having two mental problems: 1) how