I doubt you need ALL fields from ALL >tables involved in SELECT.
What if you have fields with the same name in ALL tables?
One rule:
ALWAYS use Field list in SELECT clause.
>Hi Thanks for your replies.
>My Sql select lloks like:
>Select * from TableA Left Outer Join Tableb on Key=Keyb.......
>I was trying to avoid having to get into inserting specific Filed names into the Select statement.
>If there was a Global setting like Set Nulls to Zero/Blank, it would mean I would not have to identify each field separately.
>regards,
>Gerard
>
>
>
>>>If I do a select Left Outer join, I end up with Nulls in the fields where no match exists in the Joined Table.
>>>Is there any VFP setting where I can default these to zero (if numeric) or spaces(if Character) rather then Null.
>>>I know I can post process the table and do an if Isnull() , but my prererence is to avoid having to do this if it can be done.
>>>Thanks in advance
>>>
>>>Gerard
>>
>>You could do this in your select:
>>
>>SELECT MainTable.SomeField,;
>> NVL(LeftJoinedTable.NumericField, 0000000.00) AS NumericField,;
>> NVL(LeftJoinedTable.CharField, SPACE(??)) AS CharField;
>>FROM ....
>>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.