respected sir,
i have one table. it contains field ename,itemno,item1,quantity.
i want to join table and want to gget resultsuch as ename,item,quantity.
if i m using union all,then i get result . but i do not want to use union all.
please give alternate query. reply soon plz.


thanks and regards,
dinesh kumar

First, your problem description is far from sufficient. So I have no clue what you want to join with what and which results you would like to have.

Second, why don't you want to use UNION if it gives you the correct answer? The idea of SQL is that you specify "what" you want and the system figures out the best way "how" to get the result.

c'mon, that was funny, respected sir stolze.

I didn't mean to be funny at all.