View Single Post
 
Old May 24th, 2004, 03:57 AM
Daniel Walker Daniel Walker is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 256
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SELECT f.id, f.user, fa.`field status` FROM Fault AS f, FaultAction AS fa WHERE f.ID='$F1';

Or something like that? I suspect the ambiguity was over "ID", of which there were two: one in each table.