Search results

I've got this query: SELECT worklog.[_propertyid],worklog.id,worklog.address,worklog.postcode,worklog.dateassigned,worklog.workcompleted,worklog.paymentreceived,worklog.added FROM worklog INNER JOIN properties ON worklog.[_propertyid]=properties.id WHERE worklog.[_propertyid]=properties.id...

Been using MySQL for around 10 years, very proficient with it. Loaded Access 2007 up for the first time 3 days ago to fix and redesign a database for a friend's business. Jumped in at the deep end a bit as I've had to normalise his database from two unrelated tables containing a total of 18,000...