MySQL Forums
Forum List  »  Microsoft Access

MySQL QUERIES TO MS ACCESS
Posted by: Manhao Chen
Date: July 18, 2010 08:03PM

i need to query all the quiz topics that are not linked to task

for mysql it works like so

SELECT
tbl_quiz_topics.PK_quiz_topics,
tbl_quiz_topics.quiz_topic,
tbl_quiz_topics.created_date,
tbl_quiz_topics.FK_sites,
tbl_tasks.FK_quiz_topics
FROM
tbl_quiz_topics
LEFT JOIN tbl_tasks ON tbl_quiz_topics.PK_quiz_topics = tbl_tasks.FK_quiz_topics
HAVING
tbl_tasks.FK_quiz_topics IS NULL

but i can't seem to convert this into ms access

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL QUERIES TO MS ACCESS
3086
July 18, 2010 08:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.