var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: problem in two tables
i have two tables project and task
projectid || TaskId
here project id is a primary key and task id is primary key
now i want to list list ofproject with the task id
Show a list of projects together with the number of tasks for each project. Show the project ID, the project description, and the number of tasks.
is there projectid column in the task table.. if not how can the join bw two tables to get no of tasks
ya there is the projectid in it
Originally Posted by illusiondinesh
what have you tried so far?
hint: GROUP BY