Hey all


I am trying to use this query with an Access database from VB, and having lots of problems:

Code:
SELECT DISTINCT Landscape_Name FROM (
    (SELECT Landscape_Name FROM Colour WHERE Colour='blue' ORDER BY Priority ASC)
  INNER JOIN 
    (SELECT Landscape_Name FROM Land_type WHERE Land_Type='desert' ORDER BY Priority ASC) 
ON Landscape_Name);
I'm not having much luck unfortunately I've only really used SQL for simple stuff before, and never used joins. I'm not sure if I can use those subqueries in one statement.

If you can suggest a way to rewrite this so it will work I'd be very appreciative