SQL In Crystal Report

[trongdu]

Hi
All Every One
i have two Table Employee(ID_Employee,Name_Employee,...) and
Book_Borrow(ID_Book,ID_Employee,...)
in Crystal Report i want to get Name_Employee when i display report Book_borrow.

How i can to do it?
Can you help me?
thank you.

[FaFa]

Hi,

According to u r requirement the 2 tables should link to be able to thow
Emp Name when u show the Book_borrow

so in the 'Database Expert' under the 'Link' tab
drag and drop the 'ID_Employee' from the Emloy..... tbale to Book_Borrow
'ID_Employee' , then when viewing the records of the Borrow place the
field of Name_Employee in the Group/Detail section where ever u r showing them

FaFa

[sraheem]

Hi
alternate solution
U can use sql directly in command object with a join.