using SELECT.LIST within Statement in Command Line

Hi Lars,
there is no way to achive this as far as I know,
only way might be to use a routine.

Regards,
jpb

I would prefer to be were I was last week ... ;-)

I just played around a little with SQLSELECT, maybe with a little effort this can solve your problems...

When I execute

SQLSELECT A.'@ID' FROM FBNK.CUSTOMER A WHERE A.SECTOR IN (SELECT B.'@ID' FROM FBNK.SECTOR B WHERE B.DESCRIPTION LIKE '%PRIV%')

I get the same amount of records as with

SELECT FBNK.CUSTOMER ONLY WITH SECTOR EQ 1000 OR WITH SECTOR EQ 2000 OR WITH SECTOR EQ 3000

(these 3 SECTOR have PRIV in the DESCRIPTION).

Only the output is a bit strange - but there might be better formattings, at least a "JOIN" is possible that way . . .

Documentation is www.jbase.com/new/support/41docs/jBASE%20SQL%20Engine.pdf

Enjoy and let me know if it's working at last.

You can use F1 F2 F3 instead of names with a dot (when defined in VOC, *A1 etc. doesn't work).

File VOC , Record 'F101'
Command->
0001 D
0002 101
0003
0004 Line 101
0005 50L
0006 S