Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 5th, 2006, 09:59 PM
Authorized User
 
Join Date: Dec 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default Combining Data from SQL

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!







Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining PHP and C++ Waffles C++ Programming 0 August 3rd, 2007 01:20 PM
Combining two Queries arholly Access 1 January 16th, 2007 06:40 PM
Combining tables spraveens Access 2 December 29th, 2003 11:08 AM
Combining records OCM Access 2 November 19th, 2003 04:51 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.