![]() |
Alexey admin 3/1/2007 |
Graeme, select `idS1LG`, concat(sn," ",fn) `stuid`, `vmlg1a`, `vmlg1b`, `vmlg1c`, `vmlg1`, `vflg1a`, `vflg1b`, `vflg1c`, `vflg1`, `vstu1`, `student`.`form group`AS`class`, `dateinput`, `dateedited` From `lgsem1` right join student on lgsem1.stuid=student.code
|
G
|
gdude66 author 3/1/2007 |
Graeme, try to modify your query this way: Since your "class" field is still in the main table you can choose it as Main table OwnerID on Advanced Security dialog.
|