hi i have two tables,in the first table i want 4 field and second table i want one field, i want calculate sum function in the firsttable using group by clause in the second tablefield, how to calculate please help me

why not create a view based on both the tables ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.