> I want to delete customers, but they have FK's on the table from orders
> (who has an FK on it from shipped) so would this work -
>
> delete a from
> tb_shipped a
> join tb_orders b on (a.orderid=b.orderid)
> join tb_customers c on (a.custid and c.custid)
> where custid in (1,2,3)

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns95D957A2606EYazorman@127.0.0.1...
> -sakkie69- (clintonvb@gmail.com) writes:
>> I want to delete customers, but they have FK's on the table from orders
>> (who has an FK on it from shipped) so would this work -
>>
>> delete a from
>> tb_shipped a
>> join tb_orders b on (a.orderid=b.orderid)
>> join tb_customers c on (a.custid and c.custid)
>> where custid in (1,2,3)
>
> That "and" there is illegal.
>
> The "custid" in the WHERE clause is ambiguous; you need to specify
> an alias, to tell which table you mean.
>
> And, if I may guess, the condition on custid should have b.custid,
> not a.custid. Ir doesn't seem that tb_shipped should have a custid
> column.
>
> But all this is probably easier to run in Query Analyzer than asking
> in a newsgroup.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp