sql extraction

[penfold1992]

Im totally new to SQL developing but ive been asked to attempt this job XD

I am required to extract a specific piece of information from a sql database.

Im using Oracle SLQ Developer and I need to look within the "Views" section to find the information.
The problem is that there are a lot of views and none of them look like it could contrain the relevent information.

I have a macro on excel which i can run which extracts the current table and that works ok (i van view some of the indients (if not all of them) but I have no idea what things link with what and whether the data could be located else where.

im looking for a place to start really because my "replace and hope" of the excel sheet is struggling to come up with the goods.

With ActiveSheet.QueryTables.Add(Connection:=sConn, Destination:=Range(ou), Sql:=rqt)
            .Name = "Lancer la requête à partir de ATLAS"
            .FieldNames = False
            .RowNumbers = False
            .FillAdjacentFormulas = False
            .PreserveFormatting = True
            .RefreshOnFileOpen = False
            .BackgroundQuery = False
            .RefreshStyle = xlInsertDeleteCells
            .SavePassword = True
            .SaveData = True
            .AdjustColumnWidth = False
            .RefreshPeriod = 0
            .PreserveColumnInfo = False
            .Refresh
        End With

and

rqt = "SELECT  Sequence as [Sequence], "
    rqt = rqt & " 1 as [nb loop],"
    rqt = rqt & " [Request Date] as [OPENING],"
    rqt = rqt & " 'no group before' as [Group Before],"
    rqt = rqt & " [Request Date] as [Time IN],"
    rqt = rqt & " LastModified as [Time OUT],"
    rqt = rqt & " A_Text50_03 as [Group AFTER],"
    rqt = rqt & " [Actual End Date] as [Closed]"
    rqt = rqt & " FROM dbname._DMBAS_.[Change Request]"
    rqt = rqt & " WHERE [Initiator LName]='DB' and State ='C'"

it seems that "Sequence" is the ID number
things in ' ' are just straight up text. that fills in the cell
things in [] are direct names of columns in the db tables

and i dont know what " LastModified as [Time OUT],"
rqt = rqt & " A_Text50_03 as [Group AFTER],"
these are...

can anyone give me somewhere to start 0.0
(to make it more confusing, the VB code is written partly in german, partly french and partly english...)