I hope someone can help. I have a table that has serveral records with
the same name but unique datestamps. I need to show only the records
with the latest datestamp associated with them. I am enclosing the sql
that I am working with in hopes that someone can see the problem that I
can't. I
Hi,
I'm trying to do an INNER JOIN in MySQL (3.23.39 - Linux i686) that works
perfectly when I test it in Access but MySQL is complaining and the web docs
seem to suggest I'm doing it right. Can anyone see the error? I've got
indexes on both tables on the joined field (Primary for
Is there a limit to the number of inner join statements within an sql
statement. I am using the following statement:
SELECT DISTINCT suburb_def.Suburb, church_location.Name, church_location.URL
FROM (suburb_def
INNER JOIN church_location ON suburb_def.ID = church_location.Suburb)
Is there a limit to the number of inner join statements within an sql
statement. I am using the following statement:
SELECT DISTINCT suburb_def.Suburb, church_location.Name, church_location.URL
FROM (suburb_def
INNER JOIN church_location ON suburb_def.ID = church_location.Suburb)