October 7, 2003 at 2:57 am
i have three tables all with the same structure, if i query two tables and do a union between them everything is fine, if i query three tables with a union between each then the data changes, i have a field that is a unique number, when i look at the results of the three way query it has used the first value found for subsequent rows
October 7, 2003 at 4:30 am
apologies, being a complete arse, my subquery was completly wrong and was duplicating results
but that still did not explain why the field data changed ?
October 8, 2003 at 2:47 am
note if any fiels in any table is changed (even if you put only space in it), the whole record of the table containing this field is appeared in Union query..
please read again carefully about union query
Alamir Mohamed
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply