Matthew1980 - 10:51 pm on Mar 15, 2013 (gmt 0)
Hi there LifeInAsia,
I've double & triple checked (I'm using HeidiSql GUI) and it tells me that I have successfully got two primary keys - one on the ID_number and one on the SerialNumber (newbuild table & one primary key on ID_Number on the serial table).
Ok, that makes me more confident on my given task then. I've only every dealt with tables of this sort of size..
I've tried to sort the query out and I've understood how this functions with the OUTER JOIN - essentially creating/merging the two tables on the serial numbers, the the ones where the column in the WHERE clause returns NULL, the serial number hasn't been included. Is my understanding of this correct?
I can't get the query to return what it should do, however, the query HAS sped up since doing the indexing properly, I'd missed one off the newbuild table.
I'll look at this more on Monday.
Thank you for the continued help.