[V4MD] get RecID from a long query

[Ivan Smahin]

Hello info,

Wednesday, November 2, 2005, 10:32:09 AM, you wrote:

ivc> Hi Ruslan,
ivc> I need to know if is possible get RecID from this query that works only if I
ivc> don't add RecID

ivc> query = "SELECT\
ivc> Appuntamenti_ID,\
ivc> Appuntamenti_Giorno, Appuntamenti_Mese, Appuntamenti_Anno,\
ivc> Appuntamenti_Ore,\
ivc> Persone_ID,\
ivc> Studenti.Persone_Cognome || ' ' || Studenti.Persone_Nome,\
ivc> Appuntamenti_Mediatore\
ivc> FROM Appuntamenti, Persone, Persone Studenti\
ivc> WHERE\
ivc> Persone_ID = Appuntamenti_PersoneDoc_Ref\
ivc> AND Appuntamenti_Persone_Ref = Studenti.Persone_ID\
ivc> AND Appuntamenti_Aule_Ref = Aule_ID "

ivc> I need to begin with:
ivc> query = "SELECT RecID,\

ivc> is possible?

Certainly possible. But which table's RecID you are going to select?


SELECT
      Appuntamenti.RecID,
      Persone.RecID,
      Studenti.RecID,
      Appuntamenti_ID,
      ...
FROM
    Appuntamenti, Persone, Studenti
...

-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua