Create view across multiple tables

[suesayram]

Hi All,

In plain SQL I can create a view instead of a table:

Code: Select all

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_nameA, table_nameB
WHERE condition

In AppGini v 5,5, I only see a button to create table. How do I create a view?

Sue

[grimblefritz]

As you've probably learned, AppGini does not (yet) support views. It's been discussed and the author has indicated it's a potential for a future version, but there's no ETA for it.

Meanwhile, search the forum. Someone recently posted a workaround that allowed views to be used.