Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have one script with 3 queryes ,
When i load de data i would expect to create c1, c2 and c3, but instad everything goes to c1, What am I missing ? (i have used QS but new with QV)
c1 << T_QUERY 13 lines fetched
c1 << T_QUERY 30 lines fetched
c1 << T_QUERY 45 lines fetched
This is part the script
c1:
load
CANT_QRY_1,
CANT_USERS;
sql select
CANT_QRY_1
CANT_USERS
where
CRR_ID_QRY = 1
;
c2:
load
CANT_QRY_2,
CANT_USERS;
sql select
CANT_QRY_2,
CANT_USERS
where
CRR_ID_QRY = 2
;
c3:
load
CANT_QRY_3,
CANT_USERS;
sql select
CANT_QRY_3
CANT_USERS
where
CRR_ID_QRY = 3
;
hi,
may be comma's missing in sql select?
CANT_QRY_1
CANT_USERS
Hi Oliver
No, it is not the ',' i just missed it when i rewrote the example, but it exists in my real query
Thanks
Camilo
Are you sure, you are using the different field names with these 3 tables?
May be try to use 'No Concatenate' between those tables.
Hello Settu
I added noconcatenate , and it woerked
Thanks!!