why this one give the error, what i have wrong?, please help
select * from
deliver c
inner join
(SELECT *
FROM Commission a, Track b
WHERE 1 = 1
AND a.Agent = 'BII000150'
AND b.SO = a.SO) d
on c.SO = d.t_orno
What error message?
The syntax is fine. So my guess is that you have the same column name(s) in the deliver table as in either the commission and/or track tables. You can't have the same column name appear more than once in the same SELECT statement. You will need to rename any column(s) that have the same name ... which means you can't use just "*" to list the columns 