Hi,
Can you post the structure of the tables involved? Also, it would useful to know which fields are used in relation to each other in these tables (even if the relation is a condition such as SUBSTR).

I am not clear on Table 2.

Your notes: Table 2 - Invoice Numer 'CREDIT' and DESC = M123456, Mr. Stone
do not clearly define whether Invoice number, credit, and desc are all separate fields in Table 2 or not. And, does the DESC field contain "M123456, Mr. Stone" as an example of its data?

I am also not clear on the desired result for your query. Are you looking for matching records in table 1 and table 2 for every record in table 3 and table 4, or are you looking for matching records in table 3 or table 4 for all records in table 2? Or for all 'RA' records?

I am sorry I did not understand very well.




>hi there! i am trying to create a process to bring information from four different tables. I tried to create a relation, but it doesn't work. I am not too familiar with JOINs in SELECT-SQL.
>
>One table has 1 field (item_code) ascending (15 records)
>Two table has extracted information from a larger table from an earlier SQL process that i used (credits). (invoice numbers about 1000)
>
>Third Table has current information that I am searching on (300,000 records)
>Fourth Table has archived information that I am searching on. (1.5 mil records)
>
>Essentially, I am needing to seek for the combined information from table one and table two from the data in the 3rd and 4th table.
>
>The problem with relations is that the 2nd table's field that I am using is SUBSTR for the data information.
>
>Now the combined data from table 1 and 2 are not necessarily in table 3 thus needs to seek in table four.
>
>For example:
>
>Table 1 - Item code: RA
>Table 2 - Invoice Numer 'CREDIT' and DESC = M123456, Mr. Stone
>Table 3 - Information is not found
>Table 4 - Information is found but listed as Invoice number M123456 with Description as item codes (different item codes for the same invoice number, but we are trying to find 'RA')
>
>I hope this is clear enough...i am boggled. I am trying to do a SQL with a join, but I am not sure that I am getting it right. Thanks in adavnce.