View query builder.
Check the boxes next to the fields you want to
include from the Structure page, click "Create View".
Next page would ask if you want to add another table,
then click Next.
Next page should ask which fields (if any) you want
to use to join the two tables, then click Next.
Next page asks if you want to add another table.
Keep going through until you get everything you want
in your view.
Logged In: YES
user_id=192186
Would not be better to modify Query tab on database to allow
creating view instead of select?
Logged In: YES
user_id=1512233
That would work except, most of the time when you make a
view, it's not just going to be for some simple query
like "SELECT t1.*, t2.* FROM t1, t2 WHERE t1.id = t2.id".
It's going to be some long drawn out query like "SELECT *,
(SELECT id FROM t1 WHERE t2.id = id) as id,
(SELECT name FROM t1 WHERE t2.id = id) as name
FROM t2, t3 WHERE t2.entry = (SELECT entry FROM t3 WHERE
id = 5)"
Logged In: YES
user_id=210714
Originator: NO
Well, what you suggested in your initial post is already supported via the Query menu. When your query is ready, you execute it and you can create a view from it, directly from the interface.
For your other long query, you can browse a table, click "Create view" and type the query directly.
Logged In: YES
user_id=1312539
Originator: NO
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).