Help with SQL delete - anyone?

[Fran=?ISO-8859-1?B?5w==?=ois Van Lerberghe]

Try with a sub-select :

SELECT RecID FROM tripulantes
 WHERE tripulantes.RecID IN

(SELECT tripulantes.RecID FROM tripulantes
  JOIN linktripulantes ON Link_tripulantes_linktripulantes
  WHERE L_voyageID NOT LIKE 'C%'
)

I have written tripulantes.RecID, but you can use whatever have a unique
value in tripulantes.

Cheer.

François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
Belgium


le 11/08/13 19:22, william humphrey <bill at bluewatermaritime.com> a écrit :

> Hi
> 
> This SQL select returns records
> 
> SELECT * FROM tripulantes
> JOIN linktripulantes ON Link_tripulantes_linktripulantes
> WHERE L_voyageID NOT LIKE 'C%'
> 
> but when I do
> 
> DELETE FROM tripulantes
> JOIN linktripulantes ON Link_tripulantes_linktripulantes
> WHERE L_voyageID NOT LIKE 'C%'
> 
> I get:
> 
> 13:20:30 Kernel error: 0x71000. line 2:2: unexpected token: JOIN
> 
> How do I select those records to delete which need the link to find?
> 
> Thanks for the help!
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina