View Complete Post
This must be a simple one and I am just having a blockI have two tables, Personnel and working details. I want to show all staff working in a single building but only the working details for a specific weekI have added a join which should list all staff but won't because of the date filter in the working detail table it returns only an exact match, I have added ' or is null' for the date filters but just returns all staff from all buildings
SELECT .cTblPersonnel.Firstn, .cTblPersonnel.Surname, .cTblWagesFcst.StartDate FROM .cTblWagesFcst RIGHT OUTER JOIN .cTblPersonnel ON .cTblWagesFcst.PersonnelID = .cTblPersonnel.PersonnelID WHERE (.cTblPersonnel.UnitID =544)
i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset
like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid as a compact data and combination of 3 tables from d single dataset.....
can some1 help me please.....