Cam someone help me with deleting information from a MYSQL database.
I want to delete from one table based on information contacted in another. The code I am using at present (which does not work) looks like this:

Code:
DELETE FROM ServedAt
WHERE ServedAt.Journey_ID=Journey.Journey_ID
AND Journey.Line_ID='101'
Any help would be much appreciated. Thanks.