Re: Tricky SQL statement

On Wed, 26 May 2010, Charles Wilt wrote:

On Wed, May 26, 2010 at 1:26 AM, James Rich <james@xxxxxxxxxxx> wrote:

That being said, I'm still not sure how I'd go about solving your
problem, although my first inclination would be to convert one file to
match the format of the other, and then do a join.  It would take a
little more time to try and figure out exactly how to do that, but the
goal would be to convert the TRAV# table to a table where the fields
would be 123, 1.01, 1.02, 1.03.  That's doable, I think.  Once you've
got that, it's relatively simple to compare the WO# table to the newly
reformatted TRAV# table.

Changing the layout of the work order file is not an option, though
changing the layout of the traveler procedure file is possible.  Though I
am very disinclined to do so because I don't want to perpetuate the 15
procedure limit that the work order file currently has.  I'd prefer to
keep the header/detail relationship that the traveler and traveler detail
files currently have.

Just to clarify, I don't believe Joe is telling you that you have to
change the physical format of one of the files.

Instead, consider creating a view over one of the files so that you'd
have the data from both tables available in matching formats...

Ok, but I don't understand how doing so helps. Maybe I've just had too many late nights and I'm missing something obvious?

James Rich

if you want to understand why that is, there are many good books on
the design of operating systems. please pass them along to redmond
when you're done reading them :)
- Paul Davis on ardour-dev