SQL Query Quick Question -

the following not work. error message doesn't recognize query.field4, query.field5, , query.field6 :

select table.* table ((table.field1=query.field4)   , ((table.field2)=(query.field5))   , (table.field3=query.field6)); 

how can fix this?

edit: have issue though, need able edit records , when use join clause not let me edit records.

it looks haven't put join clause in statement.

for example:

select  table.*    table join    query on   (table.field1 = query.field4) ,                    (table.field2 = query.field5) ,                    (table.field3 = query.field6) 

---

edit:

as you're using gui editor edit rows in table, might need this:

select  table.*    table   table.uniqueidentifier in (             select  table.uniqueidentifier                table             join query on (table.field1 = query.field4) ,                           (table.field2 = query.field5) ,                           (table.field3 = query.field6)         ) 

the query above assumes have primary key set on table, or column gives each row it's own unique identifier (such incrementing integer, or guid).