Hi,
my problem is, that a view doesn't contain any data while the basic
SELECT statement returns data.
I'am working with SQL studio and have created 2 views
with the following statements:
CREATE OR REPLACE VIEW V_BERICHT_1_4_4_A AS
SELECT A.*, B.AUSSCHEIDEN
FROM T_BERICHTE A, T_PERSSTAMM B
WHERE A.PERS_NR = B.PERS_NR
//
CREATE OR REPLACE VIEW V_BERICHT_1_4_4_SUB AS
SELECT A.*,
B.STUNDEN AS ARB_STUNDEN,
B.UNBEFRISTET AS ARB_UNBEFRISTET
FROM V_BERICHT_1_4_4_A A, T_ARBUMFANG B
WHERE A.PERS_NR = B.PERS_NR
AND A.DBV_NR = B.DBV_NR
AND A.BEGINN = B.BEGINN
SELECT * FROM V_BERICHT_1_4_4_SUB gives no result.
If I do the SELECT ... I get the respected data.
What can be the reason ?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
