�������� ������

[Marat Zigangirov]

÷ÓÅÍ ÐÒÉ×ÅÔ!

äÁÎÙ ÓÌÅÄÕÀÝÉÅ ÍÅÔÁÄÁÎÎÙÅ:

CREATE TABLE TA (
    KID    INTEGER NOT NULL,
    VNAME  VARCHAR(10));

CREATE TABLE TB (
    KID     INTEGER NOT NULL,
    VNAME2  VARCHAR(10));

INSERT INTO TA (KID, VNAME) VALUES (1, 'AAA');
INSERT INTO TB (KID, VNAME2) VALUES (2, 'BBB');

÷ÏÔ ÔÁËÏÊ ÚÁÐÒÏÓ × FB2RC5 Õ ÍÅÎÑ ÓÐÏËÏÊÎÏ ÏÔÒÁÂÁÔÙ×ÁÅÔ, ÈÏÔÑ FB1.5 (ÅÓÌÉ ÎÅ
ÏÛÉÂÁÀÓØ) ÒÕÇÁÌÓÑ ÎÁ Unknown field 'VNAME'

SELECT
  A.KID,
  A.VNAME,
  (SELECT VNAME FROM TB WHERE KID = 2)AS VNAME2
FROM
  TA A
---------------------------------------
1      'AAA'       'AAA'


Marat Zigangirov