Using Access as a front end
Hi
I wondered if you could give me some advice……this isn't strictly SQL Yog stuff so you can tell me to take a jump!
I am using SQL yog and have set up a simple database to muck around with. I am also using Access via the Mysql ODBC driver to access this database – no matter what people say Access is easy to use in terms of being able to view data in tables! My SQL knowledge is fairly limited at the moment but I do understand a lot about the theory of relational databases which is why I am using Access as a simple front end ( this is just so I can learn ).
I've set up this database in MySql and SQL Yog and I set up a query in Access that joins 2 tables together and produces a the 'difference' between these tables( it's called 'Find Unmatched' query in Access). In Access the query works fine ( over ODBC using MYsql) and I get the right data . When I 'view SQL' in Access and copy at past the query into MySQL the query doesn't work. I am trying to understand what is going on….I assume it's because there are different flavours of SQL? I have tried to look on the net but am getting a bit lost.
Here's the query in 'Access' SQL just incase you can help…it could be to do with the way the databases handle joins…I am just not sure.
Thanks everyone – even if you can provide a link to help me out I will take it from there.
example of the SQL I am cutting from Access and pasting into MySQL: SELECT calender.dates, gigs.Date, gigs.pk, calender.pkd, calender.pkd
FROM calender INNER JOIN gigs ON calender.pkd = gigs.pk;
