|
Subject:
|
Combining Data from SQL
|
|
Posted By:
|
hayley
|
Post Date:
|
4/5/2006 9:59:25 PM
|
Can anyone help me with this?
I have 2 tables, MainEng and ConReport.
MainEng contains masterid,logdate,at_sea.
ConReport contains masterid,logdate,full_away,sump.
I am trying to select the items (at_sea,full_away,sump) to display in the table according to the logdates of an
ID. However, for the same logdate in MainEng(which might have 12 for the mth), logdate in ConReport(might have only 8 for the mth) might not exist as there's no data either for full_away or sump.
Perhaps for the same logdate in ConReport, MainEng might not have logdate and at_sea data, so there's actually no record at all for the day.
Can anyone help on how to select out the logdates, at_sea, full_away, sump in a table? My select statment doesnt seem to work out right. if the logdate in maineng appear as 1,2,3,4,6 of the mth and Conreport appears as 2,5,7, my table have to appear as 1,2,3,4,5,6,7.
pls help fast. Thanks!
|
|
