AHHH! The blind see
Not enough coffee this morning.
Thanks Fabio!
>>DELETE ;
>>
FROM Suppliers ;
>> JOIN Products ON Suppliers.SupplierId = Products.SupplierId;
>> WHERE Products.Id = 123
>>
>
>
>DELETE Suppliers;
> FROM Suppliers;
> JOIN Products ON Suppliers.SupplierId = Products.SupplierId;
> WHERE Products.Id = 123
>
>
>>>>This code errors on the JOIN line. Anyone know why?
>>>>
>>>>
>>>>DELETE ;
>>>> FROM Suppliers ;
>>>> JOIN Products ON Suppliers.SupplierId = Products.SupplierId;
>>>> WHERE Products.Id = 123
>>>>
>>>
>>>It is ambiguous
>>>You have to declare the deleted ALIAS
>>>
>>>DELETE .... FROM
>>>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people