Results 1 to 10 of 10
Thread: Help with this simple? query
Oct 2, 2012, 09:23 #1
- Join Date
- Oct 2011
- 0 Post(s)
- 0 Thread(s)
Help with this simple? query
Ok, I am hoping someone could help me out here. I have a query which is not working properly and is driving me crazy.
I have two tables
data_table = my main working table
daily_removed = same structure as main table, but less records
what I would like to do is
update the column (Status) in the data_table, for all records where the PiNumber is listed in the daily_removed table
This is where it gets weird for me... when I do
I get a total of 1528 (which is the correct number) of matching records in the two tables
But when I go to update the Status column using
only 1214 Records get updated. '
Also, as a side note I added exactly 1214 records to the daily_removed table today ...
What could possibly be happening??
Let me know if I need to post additional info, but any advice would be greatly appretiated.