It's possible!
Hello,
I have two databases DB1 and DB2. I want show this result in FastReport:
Number Name Phone
DB1.TABLE1.ID DB1.TABLE1.NAME DB2.TABLE1.PHONE
DB1.TABLE1
ID
NAME
DB2.TABLE2
ID
PHONE
Can I do that with FastReport. I don't do it with SELECT statiment.
SELECT DB1.ID,DB1.NAME,(SELECT PHONE FROM DB2 WHERE DB1.ID=DB2.ID) FROM DB1
Thank you.
I have two databases DB1 and DB2. I want show this result in FastReport:
Number Name Phone
DB1.TABLE1.ID DB1.TABLE1.NAME DB2.TABLE1.PHONE
DB1.TABLE1
ID
NAME
DB2.TABLE2
ID
PHONE
Can I do that with FastReport. I don't do it with SELECT statiment.
SELECT DB1.ID,DB1.NAME,(SELECT PHONE FROM DB2 WHERE DB1.ID=DB2.ID) FROM DB1
Thank you.
Comments
Thanks.