HomeActive Query BuilderJoins

Joins


Hi,

Is it possible to have the query builder interpret the following join?

select *
from table1, table2
where table1.property = table2.property

I know that it can interpret sql queries which use the syntax "Inner join", however our existing application uses the syntax above and it would be great if there was a way to implement these existing queries.

Thanks in advance,
Sinead
Sinead | email
October 12 2007, 08:04 AM
Dear Sinead,

Yes, it is possible the updated build will be available on Monday. Thank you for your question.

Sergey.
Sergey Smagin | email
23 hours, 54 mins since original post
Dear Sinead,

The updated build that can recognize joins in Where clause automatically, is already available for download. Please let me know if you have any other questions regarding Active Query Builder.

Sincerely
Sergey
Sergey Smagin | email
2 days, 5 hours since original post
This topic is closed