How to: LEFT JOIN in UltraDev 1

[sfunk]

Hello.

I am trying to do a JOIN in UltraDev and it is giving me a syntax error. It is using Access as the database. I have verified that for Access this is the syntax that I should use. But it is not working. Can anyone help out?

SELECT *
FROM profile, Favorites
WHERE profile LEFT JOIN Favorites ON profile.email  = Favorites.Profile_FK  
And profile.email = 'varEmail'
ORDER BY Favorite_ID

Thank you,
steve

 

[schase]

Are you doing this in a Query inside Access? "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[sfunk]

No, should I be?

Thanks,
steve

 

[schase]

It'd be a lot easier,

Plus queries inside access handle null values much better.

When you do a query in Access - you can bring up two tables, and drag which fields are to relate - edit the join and make your preference there.

You "May" have to do relationships first (at the main screen) but that's pretty simple as well.

Give it a shot, hollar if you need help. "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart