I am parsing a file reading in information and adding it in, one row at a time, to a table (also storing filename and line number). Some of the entries in the file will simply consist of nothing more than a "base item" value. For these items, I want to look up this 'base item' (which should already be in the table) and fill in the missing values from it.
For example, on my pass through the file, I would have (there are other values being copied besides name and id, I didn't include them here to shorten it): Item name id filename linenumber baseitem A itema someid somefile.txt 1 "" (blank string - not NULL) B "" "" somefile.txt 5 A I was thinking of doing some form of UPDATE with a nested select, but this is on 4.0xx MySQL, which doesn't yet support nested queries. Any suggestions? Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
