, i was trying to get one sql statement to make it possible, but i am not sure is it possible to make a single sql statement . We have data as cost_type branchplant_code description 1 inclusion_value x1 **** n x1 5001 y x1 5033 y x1 5034 y x1 5035 y x2 **** n x2 5001 y x2 5019 y x2 5033 y x2 5034 y x2 5035 y x3 **** . N x3 5001 . Y x3 5033 . Y x3 5034 . Y x3 5035 . Y x4 **** . N x4 5001 . Y x4 5035 . Y x5 **** . N x6 **** . Y x7 **** . Y x8 **** . Y x9 **** . N is it possible to have one sql statement which will give output as ; crelembranchplant hasdutyrate hasadminoh hasfreightrate haswrhsoh hasantidumpingduty hascoverscrapduty hasdomesticrawfreight hasdies hasothermisc description 5001 x x x x x x x 5019 x x x x 5033 x x x x x x 5034 x x x x x x 5035 x x x x x x x x1 , x2 ….x9 are replaced with hasdutyrate, i could get part by part but could not combine . Thanks

nothing is clear from your post.

kindly post your question clearly.

Your question is not clear as mentioned by debasisdas.

Can u create ER- Diagram based in title for me?

@Asmawie,

Firstly DO NOT Hijack any thread. Post your question in a seperate thread.

Can u create ER- Diagram based on the following entities, Customer, Order and Item

Have a look at basics of ER Diagram (www . infocom . cqu . edu . au/Courses/spr2000/95169/Extra_Examples/ERD . htm) and try making one for yourself. If you face any issue do post here for help.