Can someone write me this query?
I want it for the Mir 3 program I am slowly making (see here > > http://www.lomcn.co.uk/forum/showthread.php?t=59554)
Firstly, because I am not good at using any other than basic SQL queries, I would personally fetch all items from all 4 tables and then use my VB6 program to find the duplicates..
I assume there is an easier way of finding the duplicates in these 4 tables by using a single SQL Query????? What I am after is to find each instance where the MAKEINDEX is found in more than one place in any of the tables..
TBL_SavedItem=FLD_CHARACTER,FLD_MAKEINDEX,FLD_INDEX
TBL_Item=FLD_CHARACTER,FLD_MAKEINDEX,FLD_INDEX
TBL_DHLBOX=FLD_FROMWHO,FLD_ITEM_MAKEINDEX,FLD_ITEM_INDEX (WHERE FLD_READCHECK=0 & FLD_CANCEL = 0)
TBL_ItemMarket=FLD_SELLWHO,FLD_ITEM_MAKEINDEX,FLD_ITEM_INDEX (WHERE FLD_SELLOK=0)
So.. can it be done, can someone do it for me?
/Mick
I want it for the Mir 3 program I am slowly making (see here > > http://www.lomcn.co.uk/forum/showthread.php?t=59554)
Firstly, because I am not good at using any other than basic SQL queries, I would personally fetch all items from all 4 tables and then use my VB6 program to find the duplicates..
I assume there is an easier way of finding the duplicates in these 4 tables by using a single SQL Query????? What I am after is to find each instance where the MAKEINDEX is found in more than one place in any of the tables..
TBL_SavedItem=FLD_CHARACTER,FLD_MAKEINDEX,FLD_INDEX
TBL_Item=FLD_CHARACTER,FLD_MAKEINDEX,FLD_INDEX
TBL_DHLBOX=FLD_FROMWHO,FLD_ITEM_MAKEINDEX,FLD_ITEM_INDEX (WHERE FLD_READCHECK=0 & FLD_CANCEL = 0)
TBL_ItemMarket=FLD_SELLWHO,FLD_ITEM_MAKEINDEX,FLD_ITEM_INDEX (WHERE FLD_SELLOK=0)
So.. can it be done, can someone do it for me?
/Mick