Hi, I hava a puzzling problem I'm trying to get my head around and I need some help.
I have two tables with related content in them and I'm trying to update the records in one based on matching records in the other. Shouldn't be too difficult right? Query #1: Identify records in table #1 that need updating -- Set A select bcid from playlists_content where embedcode is null and bcid is not null Result: 98 records Query #2: Source records in table #2 -- Set B select bcid from bl_0114 where bcid is not null Result: 6,079 records Query #3: What is the overlap based on the link field bcid? -- A intersect B select bcid from playlists_content where embedcode is null and bcid is not null intersect select bcid from bl_0114 where bcid is not null Result: 0 records Hmm... Query #4: Verify that A minus B = 98 (since there is no overlap) select bcid from playlists_content where embedcode is null and bcid is not null minus select bcid from bl_0114 where bcid is not null Result: 76 records Query #5: Verify there are no missing link fields select bcid from playlists_content where bcid is null Result: 0 records What have I missed here? Table structures: BL_0114 ID varchar primary key NAME varchar BCID varchar PLAYLISTS_CONTENT ID varchar primary key EMBEDCODE varchar BCID varchar not null Any help deeply appreciated -- Marcus -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
