General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
LEFT OUTER will give the records in the sowgts table even if they don't have a match in some of the other tables. If this is what you want, LEFT OUTER is ok.
Vlad
>Ok, I figured it out. I was right in the first place with using all LEFT OUTER JOINs. The problem was that I only had one part of a two part key on sotran.
>
>Thanks, both of you.
>
>Michelle
>
>
>
>
>
>>If there is only one match in all the child tables, then a INNER JOIN should get you only one record per record in sowgts.
>>
>>>First match? There's only 1 match, so I don't know where first comes into it.
>>>
>>>Each record in sowgts has
>>>* a skid in soskid
>>>* a sales order in somast
>>>* a line item in sotran
>>>* a customer in arcust
>>>* an address in soaddr
>>>* a highest numbered skid in highskid
>>>* a net weight in netwts
>>>
>>>I just want to put all of this info into the same record. What would I group by? There's no groups?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only