Re: conditional join?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"Bart" <Bart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:148C59C9-1EFA-4E77-944E-E7D20C199C25@xxxxxxxxxxxxxxxx

"Chris2" wrote:


"Bart" <Bart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D49F1267-7714-487A-B154-1FE4099E44AD@xxxxxxxxxxxxxxxx

"Chris2" wrote:


"Bart" <Bart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8DCDDF8B-1F08-477A-8782-0A9FAD40663C@xxxxxxxxxxxxxxxx
Hi Chris,


<snip>


Sincerely,

Chris O.


<snip>


Can you please post your table structures, including indexes and relationships?

I have some ideas about to do this, but until I can build a pair of tables that match
yours that are loaded with the data, I will have no way to find out if they will work.


Sincerely,

Chris O.



<snip>

I'm not sure how much information you want but I will supply the SQL
translation of the Progress schema for a number of tables below.

Ok, two things are still missing.

I need a mini-chart that translates the previously supplied level1-4 column names into the
real column names so that I know what sample data goes where.

No primary keys or foreign keys were shown. Please add those declarations (just those, no
need to repost the whole set of table descriptions).


Note for future consideration: When supplying DDL SQL, non-relevant columns (those that
aren't going to be used in the query/process, or those that do not describe primary or
foreign keys), may be omitted in a newsgroup posting.



I will include the Progress procedure I am using to achieve the results.
While you may not be familiar with Progress the language is quite easy to
understand and you should probably be able figure out more easily what it is
I am after from reading the code. It may not be the best implementation but
it is working.

I am glad it is working. While I can guess about what some of the Progress code does,
guessing isn't what you need and me doing that won't do you any good. (I would just be
stumbling through one interpretation after another, with you correcting me most of the
time.)



In SQL is it possible to include some conditional statements within Select
(e.g. IIF, CASE) to determine the level of provenience recorded in the photo
record and to direct the join to one of four instances of the crmProv table
each with different join critera?


I suppose you could try to use IIF and SWITCH, but I wasn't planning on that.

I was going to try querying for all 4-column matches, and then doing a query for all
3-column matches where NOT EXISTS all the 4-column matches, and then doing a query for all
2-column matches where NOT EXISTS all the 4-column and 3-column matches, etc.

Does that even remotely sound like what you are trying to achieve? (It does to me, but
that doesn't mean I am right.)


Sincerely,

Chris O.


.

Relevant Pages

  • Re: conditional join?
    ... "Chris2" wrote: ... I'm leaving a the moment, but I'll be able to look at it later tonight and/or tomorrow ... Chris O. ...
    (microsoft.public.access.queries)
  • Re: Home Networking
    ... I have now found from the pc the laptop however still am having problems ... <SNIP> ... We know that the browser service is running on Computer (such an original name ... Check both Chris and Computer, ...
    (microsoft.public.windowsxp.network_web)
  • Re: can you post anything Mr. Christensen?
    ... Cuba, he wrote back that it was Rudy Rummell. ... You really seem to be reaching here, Chris. ... Lobbying comrade Dan. ...
    (soc.culture.cuba)
  • Re: C++ a little help please.
    ... | template <class ResponseType> ... sub menu', etc..., while providing dynamic menu' at runtime ... Chris Val ...
    (alt.comp.lang.learn.c-cpp)
  • Re: Extremely undignified wizarding names
    ... <TOTAL SNIP> ... Given that Chris's father support the war ... rest of content of the post wasn't required since Chris was not commenting ... the Father DID control the finances of his children while they still ...
    (alt.fan.harry-potter)