hi all,
I try
select purc.trn_no,purcsub.item_no,purcsub.qty,emp_no,emp_nafrom purc left join purcsub on (purc.trn_no=purcsub.trn_no) left join emp on (purc.emp_no = emp.emp_no)
postgresql not run,please help,thank