Aqua Data Studio 15.0.0-dev-52
Database: Sybase IQ 16.0
1.In ADS,Click on File menu
Select Options
In Options window,go to Query analyzer and expand it
Click on Sybase IQ server
Check Auto Completion & Auto Complete On All Schemas option(ignore if checked)
Click on OK
2.Connect to a Sybase IQ database
Open New Query Analyzer window
In Query Analyzer window
Write Left Outer Join query between two tables as follows:
SELECT "Order1".[ord2],"Order1".[ord1],"Purches".[prc2],"Purches".[prc1]
FROM [dimentrixgroup].[Order1] left outer join [dimentrixgroup].[Purches] on "Order1".[ord1]="Purches".
GO
Make sure that script should break in two lines and table name should come down on next line then
enter '.' after table name,display a drop down having list of column name but it is displayed at first line where line is broken
it should display on next line after '.'
Please go through screenshot(drop_down_list.jpg)