Re: Sequel query not working in strsql

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

Try

SELECT   a.*, ...



Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144


On 7 January 2016 at 11:59, Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
wrote:

> I just wanted to see results of an Sequel query but this gives message
>  Token . was not valid. Valid tokens: FROM INTO.
> because when i try to run in SEQUEL it gives permissions error.
>
>
> SELECT   *.a, ohtype, ohotic, ohoush, ohiord, ohcuno, ohdeno, ohexr3
> FROM     sroorspl a, sroorshe c
> JOIN     olorno=ohorno
> WHERE    a.olsrom='100' AND a.olords=20 AND olstat=' ' AND EXISTS
>    (SELECT   *
>     FROM     qgpl/ord114 b
>     WHERE    a.olorno=b.olorno)
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.