SELECT
A.AID, L.LID,
L.CT,
PA.PS
FROM A
full outer JOIN PA
ON A.AID = PA.AID
full outer JOIN L
ON A.AID = L.AID
order by PS Desc
Issues.
The query works above. But when I add the where class below it down not work.
WHERE A.STAT in ('ABC','hlp')
Also, the PA has a PS output of thousands of records with null but when I do a select * from PA, there is only 6 records that are NULL which is correct. There should only be 6 records that are null.
Last, The table LES contains FIELD LESDesc Contains the Description is not yet joined. Where should i place the join? Inner query? Thank you
Thanks in Adv. I am trying to work with 4 tables.
The query works but would like to enhance.
SELECT
A.AID, L.LID,
L.CT,
PA.PS
FROM A
full outer JOIN PA
ON A.AID = PA.AID
full outer JOIN L
ON A.AID = L.AID
order by PS Desc
Issues.
The query works above. But when I add the where class it down not work.
WHERE A.STAT in ('ABC)
Also, the PA has a PS output of thousands of records with null but when I do a select * from PA, there is only 6 records that are NULL which is correct. There should only be 6 records that are null.
Last, The table LES contains FIELD LESDesc Contains the Description is not yet joined. Where should i place the join? Inner query? Thank you
this is what I would like to show All unique AID from the Table A with the the 3 tables.
I understand there could be a one to many rel from A to the tables below.
I would like to show
Table PA and show PS,
Table L and show Cat
Table Les and show lesdecs
The tables below has the following fields.
Table A, Contains AID
Its got the most records.
PA
Table P, Contains AID to join aback to Table A
-Contains field PS that we would like to show in the results.
note that AID from table A can contain more than one PS from PA
Table L
-Contains Field AID to Join back to A.
--Contains Field Cat that we would like to show in the results.
---Contains Field LID
Note A can have multiple Cat or LID
Table LES
-Contains Field LID to Join back to L
-Contains FIELD LESDesc that we would like to show in the result
note: not sure if this is a one to many in L to LES since I we only need LESDesc