user422318

top accounts reputation activity favorites subscriptions

all accepts posts badges comments revisions reviews

May 18	awarded	Student
May 18	asked	How can I learn A/B testing independently?
Oct 17	comment	Adding new fields to an existing table, inserting data into proper position, then joining I had problems using your statements. Here's what I think I can use, based off a test with a small data set: UPDATE existingTable INNER JOIN incomingDataTable ON existingTable.Email = incomingDataTable.Email SET [existingTable].[newField1] = [incomingDataTable].[newField1], [existingTable].[newField2] = [incomingDatTable].[newField2]; I think that INNER JOIN doesn't cause any problems.
Oct 17	comment	Checking for key violations in Access append query By the way, can I assume that these key conflicts are duplicates I'm trying to import?
Oct 17	comment	Combining two tables using UNION ALL You can use either APPEND or UNION ALL to combine tables, then? <br/> So UNION combines tables and removes duplicates?
Oct 17	comment	Adding new fields to an existing table, inserting data into proper position, then joining "Clarifying your Scenario 2. I'm assuming you mean you want all the rows from existingTable even if there is no match on the Email field with either of the other tables. In this case, a LEFT JOIN is what you want:" <br/> There's another constraint I forgot to mention. Accidentally, there are a different number of records between these tables even though they should be 1-to-1. Yeah, the important thing is that ALL records in existingTable are shown. I think LEFT JOIN is the right thing. <br/> Thanks for the selects for the scenario 1 response. I think that sounds correct. Trying this out now.
Oct 17	comment	Current primary key is ineffective at preventing duplicates. Does this sound like a good way to rearchitect my tables? Marc: My three tables (even though they should be one-to-one) have different numbers of records. I think this may have happened from inputting data into one table and not the others, but I'm not completely sure. :/ Is the unique_index like a record number? I'm not sure that would work if I have a different number of records in each table.
Oct 17	comment	Current primary key is ineffective at preventing duplicates. Does this sound like a good way to rearchitect my tables? Sorry, my above comment was posted prematurely. I just added to it, and then saw your answer after publishing it. Does your answer still apply to my edited comment?
Oct 17	comment	Current primary key is ineffective at preventing duplicates. Does this sound like a good way to rearchitect my tables? Based on a search I did, I assume that "Identity" column means a field where each record is a unique value. (The first record might have "1" in that field, the second will have "2", etc. Each will be unique.) How do I make sure that, when I create identity columns in the other two tables, that the keys correspond to the right records? I have a problem where the three tables have different numbers of records. This may have been from inserting new records into one table and not the other because of incomplete info & inexperience.
Oct 17	comment	Checking for key violations in Access append query Cool. So to delete these conflicts, here's what I think I'd do. I'd do DELETE * FROM existingTable WHERE (SELECT * FROM existingTable INNER JOIN incomingDataTable ON existingTable.key = incomingDataTable.key). Right?
Oct 17	asked	Adding new fields to an existing table, inserting data into proper position, then joining
Oct 17	asked	Current primary key is ineffective at preventing duplicates. Does this sound like a good way to rearchitect my tables?
Oct 16	comment	Combining two tables using UNION ALL I think you said that I must be careful and make sure that each field is paired with the correct field. Is that correct? (I just discovered how to do this in Access. :) By the way, how does UNION ALL differ from appending?
Oct 16	comment	Combining two tables using UNION ALL I used asterisk as wildcard. I just learned today that I should pair each field and not use asterisk. :)
Oct 16	asked	Checking for key violations in Access append query
Oct 14	asked	Combining two tables using UNION ALL
Apr 13	comment	How do I do a reveal against a black background? 3. How would I do this in reverse? Assume that I have my game world being drawn and the game ends. The black should come in from the corners and the circle will grow smaller until there's nothing but black.
Apr 13	comment	How do I do a reveal against a black background? This is really awesome, thanks! I have a few questions though. \| 1. I intend to use this effect to reveal the position of the player's avatar, and then the surroundings. So, I want this to originate at the player's coordinates of (hermes.currentX,hermes.currentY). How can I do that? \| 2. The reveal appears to draw a white background or blank canvas. I want to keep my game map as the reveal happens. How can I do this?
Apr 13	accepted	How can I stack two same-sized canvas on top of each other?
Apr 13	comment	How can I stack two same-sized canvas on top of each other? Handling clicks for both canvas works for me and I think I'm on my way. Thanks for your help.