Query / Using a Query as a Record Source

[Mike Bollinger]

I am learning Infomaker and I have come from a Microsoft Access and
Visual Foxpro background. I have a couple of questions that I would
like to have clarification on:

Using Infomaker 8:

1. Is there anyway to work with SQL syntax outside of the report or
form painter? Can you edit the syntax in the Query Painter?

2. Can a query be used as a record source? If I create a query:
"Select fname & " " & lname as fullname from table1"
and call the query q1

Is there anyway to use "select name, address, city from table2
where name in (select fullname from table1)"

3. Is there a way to group by a computed field? It seems to only
give you the table fields to group by.

Thanks for your help,
Mike Bollinger